- Control Center Global Updates
We are now using Control Center to provision projects and as we are learning how to use it better we need to keep doing some updates to the templates and the existing projects we have already provisioned. I have been using the Global Update feature, but when I use it to update a Dropdown list in a Dropdown column, the…
- formula for dates
i have a question for a data sheet with completion dates i want to create a formula to count the lines marked completed with a date.. im using count if but is not working i was able to count the entries when no date available bu using ,"") at the end of the count if after my selection if any one can help me out with the…
- Changing a Date (mm/dd/yyyy) to Month Year (January 2019)
I copied this from another post and simply substituted my date range (from another sheet) and It is returning "UNPARSEABLE". Any suggestions? =IFERROR(IF(MONTH({Quality Database Range 1}@row) = 1, "January ", IF(MONTH({Quality Database Range 1}@row) = 2, "February ", IF(MONTH({Quality Database Range 1}@row) = 3, "March ",…
- Solicit Comments, but prevent user from viewing other's comments
Hello All, We use comments pretty extensively to communicate updates and share "next step" info internally. I would like to request updates, and include comments to external collaborators, but prevent them from seeing what has been previously posted. Is there a way to do this? Thanks, Alex
- 计算和比较日期列的形式' based worksheet
I would like to know how I can count number of activities (rows) which are completed ('finish' date column) at or before 'planned finish' date. In the same formula it should only be counted when 'complete' column is ticked off and empty cells should not be counted. Note that this is a 'form based' worksheet, meaning rows…
- SUMIFS for multiple criteria
This should be fairly simple, but I am spinning on this syntax. Trying to sum my "Invoiced" column if the Year Column = "2019" and the Type Column = "Expense". I have tried a few variations, but this is what I think should work? =SUMIFS(Invoiced:Invoiced, Type:Type, Expense, Year:Year, 2019). I have tried quotations around…
- how to see the collaborators ?
I don't understand why you don't see the name of the collaborator and just show your email. What remains to be done so that it looks the same as the rest? See images please. Thanks
- Conditional lock
Hello, I am trying to develop a shareable sheet in which some tasks are listed along a row and check boxes are used to indicate a task has been completed. Would it be possible to lock these checkboxes if its previous one haven't been checked? In this way a process flow would be enforced. Perhaps the solution would include…
- Rotate Text?
Can titles of columns be rotated so more can be squeezed into view?
- Master build schedule to sync with other sheets?
I am not having any luck searching for a solution to this. My company has a production schedule in Excel. It changes daily. Builds get added, removed and moved around on a regular basis. We have two different engineering departments that are managing their work load in Smartsheet. The two departments have very different…
