-
Project Health Calculation
Please can you assist. I am currently using the SS Standard template Schedule Health Formula : Project Heath Formula =IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green")) My issue - Milestones which should not be are showing green because the Duration is Zero (see schedule formulas…
-
How do I do a row request?
I am trying to create groups of tasks that can be used by using a filter. Unfortunately I need to be able to know the row# of all added rows in order to have the new rows visible for each group. I want to have a cell that marks the start of a section and one that marks the end. The ones between need to be filled with the…
-
COUNTIFS Referencing another sheet and pulling data from a specific time period
Hello, I am trying to create a formula that will pull the number of times an entry was submitted for a specific location from another sheet, but I want to set the date it should start counting from and no end date. The data that the formula will compute I will then use as a reference cell for a chart I created on a…
-
Help w/ COUNTIFS and ISBLANK and NOT ISBLANK
Hi team - I have 2 columns (Seat and Open Req) that I need to count: When Seat = Filled and Open Req is not blank When Seat = Filled and Open Req is blank I'm struggling with the COUNTIFS sequence to get this to work. Any help would be greatly appreciated.
-
Project stage and date in the Future
Hello Smartsheet super formula humans! I need some assistance! We are trying to create a formula where a checkbox is checked if the project meets the below criteria. Recurring On hold Pending approval + In Progress with a Go-Live date of after 3/31/21 The Recurring is its own checkbox without a formula, the On Hold,…
-
Formula to Automatically Return Column Pending
I have a Smartsheet that is being used to login dates as an item is processed through various steps until completion. I would like to create a column that automatically shows what step in the process the item is on. I can do this by combining if/then formulas, but there are at least 15 steps and I am hoping there might be…
-
How can I add days to dates based on text in another column?
I need to have a specific number of days added to a date that is in Column A, and have it add days to Column C, based on the text that is in Column B. Example: Column A is SC (needs +20) Column B is 7/29/2020 Column C should = 8/18/2020 I have found that (A1,"SC",B1)+20 works per text, but I have 12 different variances of…
-
Auto Populate Today's Date
When a condition in "Column A" changes to "YES", I want the date in "Column B" to automatically enter today's date. How can I do that. If I use the TODAY function, that cell will update to today's date every day - and I only want the date "Column A" changed to "YES".
-
Help w/COUNTIFS and multiple NOT(CONTAINS) functions
Hi team - I created a formula to count the number of numbers of errors in a specific month and does NOT CONTAIN "general counsel" in the Division Requested By column, the June example works: June example formula: =COUNTIFS([Main row]:[Main row], 1, Created:Created, IFERROR(MONTH(@cell), 0) = 6, [Incorrect…
-
Next Payment Due
Using MIN COLLECT to select from dates the next payment due date. Nothing is being returned. I can't figure out what I am doing wrong. Next step would be to select the value associate with the date. =MIN(COLLECT([Year 1 Due]1, [Year 2 Due]1, [Year 3 Due]1, [Year 4 Due]1, [Year 5 Due]1, [Year 6 Due]1, <TODAY()))
