-
Counting the number of Red Symbols in Parent Rows Only
I would like to count the number of REDs for Parent cells only (not children). Any help would be much appreciated.
-
Building A Sheet That is Agile Velocity Focused
It won't let me hyperlink a copy of it but here is the URL for those who trust I'm not trying to do anything scary. https://drive.google.com/file/d/0B8APP67r815BaVdmRkxrRlVKRDA/view?usp=sharing So this creates a gant shart that shows them waterfalling off one another (but only shows where they end and not begin) It also…
-
Centering Title of Widget
Hello, Does any know how I can center a title located in a sights widget?
-
Help with nested IF statement using AND
Hello Community, I have created the below formula that SEEMS to be working but is not showing up with the color coding that typically happens when you have all your formula ducks in a row. It is returning a result, not an error, but I’m concerned there is still something missing since the text is showing up all black. See…
-
Feature Request
I have used Smartsheet for years and find it to be the best Project Management platform to date. I have a few features I'd like to suggest be added in the near future... please note if you'd find any of these helpful too. Hopefully this will help grab Smartsheet Developers/Engineers attention. - "View As (Other User)"…
-
If cells in formula are blank, then leave the formula cell blank
I have three main columns: Planned Start Date, Planned End Date, and Date Completed I am utilizing the formula below to determine which tasks are done and late in the status column. I would also like the status cell to be empty if the date completed cell is empty. How can I do that? For some reason ISBLANK isn't working…
-
Formula To mark a row as recent
Hello, I would like to type the word recent into a cell based on it being recent(created date is in the last 7/ days). Otherwise I want the Cell to be blank. This is what I tried but get #UNPARSEABLE =IF([Created]246>=TODAY(-7), "Recent", false) I'm working in a quotes sheet that can get very long and I want to create a…
-
Group View for Resources showing as 'Portfolio Template'
Hi all, So I have several projects located in a 'Portfolio Template' and I want the group view to show the Project name rather than the sheet name which is 'Portfolio Template'. Is there any way i can change the group view to show the project name rather than the sheet name?
-
Calendar View - Printing
When printing in Calendar view, the names of Months and the Days are very faint, almost unreadable. I can change colour of cells but can't seem to change the names of months and the days to bold or some darker colour. I'm a new Smartsheet user so won't be embarassed if you let me know it is something very simple.
-
How would I add an attachment via a Webform?
I am working on a webform that would request actions to help track and manage contracts. Is there a way to add file(s)/attachments to the smartsheet via a Webform?
