Formulas
Discussion List
- Hi all, I'm creating a sheet summary report with the intention of summarising when passed tasks were completed relative to planned completion data i.e. early, on time, late. To do this, I'm using an =…
- Hello! I'm currently trying to calculate the average amount of workdays it takes for each person to complete a specific request on a metrics sheet from a parent sheet. For example: How long does it ta…
- I am trying to have a cell show a colored health dot based on the other dots in the same column. This cell basically shows red if there any red dots, yellow if there are no red dots and at least one y…
- This formula surfaces 'At risk tasks' to a project rollup dashboard report. It does so based on the criteria of due date in the past and status other than complete. =IF([End Date]@row <> "", IF(AND([E…
- Hi, everyone. I'm very new to using Smartsheet and am having some troubles regarding start/finish dates. I'm trying to find and use the correct formula/automation to change the start dates if the prev…
- Smartsheet does not like multiplying 0's so I need some help. I can get around this by adding more columns in but that will be painful with 13 similar sheets! lol There has to be a way to do this with…
- Hi, I am trying to find the maximum value of values in Column A based on the year it is occurring as per dates listed in Column B. For e.g., finding the minimum value for all 2015 values in Column A. …
- I want to add a Metric widget to a Dashboard that totals the number of projects that I have in another workspace. Each schedule (sheet) in that workspace has standard summary fields that I use in Repo…
- Hello! I have set up an Index/Match for the Secondary ID to be matched to the Sites Under Consideration. This works for the rows where there is only 1 selection in the Sites Under Consideration column…
- I am trying to create a metric sheet to document how long response and acknowledgement times are taking per month for record keeping. I have a sheet that has an acknowledgement SLA column and a "date …
