-
Calculating lateness
I'd like to indicate when activities start slipping behind baseline start dates, using conditional formatting. To do this, however, I need to be able to calculate the difference between the Actual start date (entered manually) and the Baseline start date (locked). What is a formula to do this calculation?
-
Send Update Request
Hello All I want to share an exciting SS discovery! I am currently doing the Smartsheet Project Management course. The send Update Request function will truly transform my work life. This option does not require the person being requested information to log into smartsheet to answer the specific questions I require…
-
Error When Saving Smartsheet
I have been searching the existing posts for something like my current experience, to no avail. This morning, I have been having trouble with my program management sheet. All of our current projects roll up to this sheet, and this sheet goes to my VP. It is large, but has always been large. I haven't changed anything…
-
Percent Complete not adding up
I need some help figuring out how to make my "% Complete" column reflect the actual percentage using my "Hours" column and not "SLA" (days). The sample below is clearly incorrect. It should be more like 64% complete. I'm totally stumped.
-
Request Update -- Can you categorize assignees into TO & CC?
Hi - I use the request update feature a lot - but, would love the ability to send the main "request" to the person doing to task and perhaps their manager or teammate as a CC? When I send to multiple people - there is always confusion on who should answer the update. Those CC'ed would see that their are only a copy & not…
-
Feature Request: Reminders with a custom days before/after or more day options
I am interested in setting up a reminder for rows where the 'Target Date' column is 30 days away. I'm only able to set reminders 14 days before a date, but it would be really helpful to send reminders at least a month out for more long-term projects.
-
Can you reduce the depth of a row so only the 1st or 2nd rows of cell content are on view
-
Automatic Column Updates?
Hi I am trying to create a formula that is set for the whole column in the sheet. What I want to happen is whenever the Status of the Harvey Ball is full, the "Done" column well create a check mark in the cell. Is this possible? If so, how? Thanks.
-
Signing smartsheet
Is it possible to place signatures onto the smartsheet? i have issued safety bulletins and toolbox talks to install crews who operate remotely andf i want them to prove they have read and undertsood the safety alerts and toolbox talks by signing the Smartsheet? I will be audited and want to be able to prove to teh auditor…
-
Filtering Calendar View
Is there a way to filter the calendar view to show more information (from other columns) rather than just the primary column information?
