-
Multiple Approvals Per Row
Hello, I am looking for a workflow solution to our document approval process. Currently we have a Confluence page where five individuals attach a picture of their signature. I would like to set up a sheet to manage approvals of several project documents. The approvals function can currently do this, however, when I send…
-
I have opened the previous file with datas. I copied the original file and played with it, added som
And added new information, but my diagram on dashboard is not changed with the new set of data.
-
Formula Quesiton
I have 2 columns - one Engagement and one Desired Engagement - If the two columns are not equal, I want the cell color to be yellow as an indicator. If the two columns are equal then, do nothing. How can write that formula in smartsheets ( since I haven't figured out a way to do it with conditional formatting)?…
-
Looking to turn Predecessors cell into a comma delimited list without "FF", "FS", "+x d " etc.
Hello, Looking for some help from skilled smartsheet formula writers on how to copy the contents of a predecessor cell into another cell but without leads, lags, "FF, FS, SF etc.". TO give you the full picture of what I am trying to achieve: My ultimate goal is to be able to identify a list of successors for a given row. I…
-
Flag or Conditional Formatting?
I want a way to 'flag' a cell if it is out of range of two other cell dates. I haven't been able how to do that with conditional formatting because I can't set a condition to say if "this column" is NOT between "this column" and "this column" (where the dates change for each row). Is there a way to do that? I thought I had…
-
Formula to change line item to 'at risk' when due date is passed
Goal: When a finish date is passed on a line item, I want the status column to change to 'at risk'.
-
How to create a time gauge or something similar?
Hello, I am trying to create a widget to display on a dashboard. This widget will give the viewer an immediate idea of where the project is in the project timeline. Ideally, the widget would look like the time gauge image attached. There would be 4 segments instead of 3. The needle depicts where the current date falls on…
-
Project Health formula Help needed
=IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", IF(TODAY(10) >= [End Date]@row, IF([% Complete]@row < 0.75, "Yellow", "Green")))) These is what I want the rules around the health to be but when i enter the above formula the cell is blank some of the time. If scheduled end date is…
-
Sample Data Center Project Plan
Shot in the dark - but does anyone have a SS data center migration plan they might have used that you would be willing to share? I am trying to determine if such a large scale project would work using SS. I've looked on PMI for samples but did not find any. TIA.
-
Alert Task Owner when change is made by someone else
Hello All, I have a task sheet that is shared with multiple users. I have a field for the name of the Project Manager and a field for the name of the Task Owner. I would like the PM to get an alert when the row is updated but only if the update comes from someone other than the PM. In other words, if the PM is updating the…
