-
Formula for health status of overall project
I was using the below formula to provide the health status of the overall project, but its not working. The result (green, yellow or red) is supposed to come back with the majority of the tasks that are in that color. In doing my test, most of my tasks were in red status, but the result for the overall project came back…
-
Is there a formula that can capture the date when a cell changes?
I have a list of dropdown categories to capture the project stage and would like to capture the date when the project stage changes. I also have a list of dropdown categories with the project stage owners that I would like to capture the date of when this changes. My goal is to see how long the project takes on each stage…
-
SUM cells with formulas not working
Hello, I have a sheet with a column of cells with formulas in them. These formulas produce numbers. Then I have a second sheet, where I have a formula in a cell that references the first sheet's column with numbers. This formula in the second sheet is asking to SUM some of the numbers in the first sheet's column and divide…
-
Can a smartsheet form autopopulate a PDF? Or can you push every row to a recreation of the form (in
Hi, We are using forms to gather group ideas for creative projects. After, we would like to take each form submission or row and populate to a formatted PDF that can be presented to the managers for approval. Is there a way to push a form submission to populate a PDF? Or link cells in smartsheet to a PDF? Or any other…
-
# of Tasks Assigned to Each Person from a Folder
Hi All, Working on trying to find a solution to the following. We have a dashboard we'd like to use to understand the workload across all of our standard projects. Specifically, we want to know the number of tasks assigned to each person by health status. The Folder "Standard Projects" includes multiple sheets, and will…
-
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…