-
Smartsheet workflow not sending emails
Hi, I have created automation workflow, requesting approvals. After the trigger point, Smartsheet is not sending emails to the users assigned with the task. But, they are getting notifications in the Smartsheet, but not emails . Can someone please help me in this. I have the restrictions checked, but nothing is working.
-
Percentage formula
I am trying to get a percentage of admin from the total hrs logged in the individual utilization collumn using this formula but it is not working. =IFERROR(Admin@row / [Total Hrs Logged in]@row, "") please help.
-
Discrepency in Total Float in print and the main sheet.
Good day, Today, I encountered an unusual situation when printing the Task Sheet. Please find attached copies for comparison. On the main sheet, the following activities 22, 24, 26, 27, 29, 31 all fall under the critical path, which is correctly displayed as 0 total float. However, upon printing, the same 22, 24, 26, 27,…
-
Report will not average negative values correctly for baseline variance.
Hello, I have a project sheet that calculates Variance from the schedule baseline. I am trying to create a report from this sheet that shows the average Variance for each supplier (from the Assigned to column). As you can see in the image, some of the variance values are negative, and some are positive. When I try to use…
-
"submit and open new form" option
Would be great to have an option that allows a forms user to complete a form and then begin a new submission for that same form. Right now you can hit the back button but then you have to overwrite all the previous answers.
-
elapsed time duration
This has been requested for years. Standard in MS Project. Need to allow for task-specific 7day workweek in projects that are set to 5-d work weeks. Common for projects imported from MS Project to SmartSheet.
-
Admin Log
An important user of mine was deleted. I need to find out if I did that by accident or if someone else did. Is there a log of admin things that have been done?
-
Converting Sheet Summary Metrics to be used on Dashboard
Hola! What's the best way to convert sheet summary metrics into data that can be visualized on a dashboard? Muchas gracias in advance.
-
No health for parent or milestone tasks
Here's my Health column formula: =IF([% Complete]@row = 0, "", IF([% Complete]@row = 1, "Blue", IF(AND([% Complete]@row < 1, Finish@row > TODAY(+5)), "Green", IF(AND([% Complete]@row < 100, Finish@row < TODAY(+6), Finish@row > TODAY()), "Yellow", IF(AND([% Complete]@row < 1, Finish@row <= TODAY()), "Red"))))) For the MOST…
-
Issue with "Formula To Indicate A Task Is Ready Because Predecessors Are Complete" Solution
So I have tried both the 2 & 6 column version of this solution (see link below), but things are not working as I would expect. Formula To Indicate A Task Is Ready Because Predecessors Are Complete…