Trending in Formulas and Functions
-
Giving a Parent Row a level score
Hi Is it possible to give a parent row a score based on its hierarchy in the row grouping? ie The top level of grouping being level 1, next level of grouping level 2, but only where the row is a parent? I am currently using =COUNT(ANCESTORS()) but this gives a task a score even if it doesnt have a child. It would be great…
-
Count on condition between two dates
I have been racking my brain on how to write this formula - for some reason, it did not count anything What I am trying to do is: Count "Complete" between two dates. The formula goes: =COUNTIFS([Actual Start Date]:[Actual Start Date], ">=12/26/2022", [Actual End Date]:[Actual End Date], "<=05/26/2023", Status:Status,…
-
IF formula with a calculation
I am new to smartsheet and I want to combine an IF statement with a calculation. I have instruments that I bill differently. So I want to say if the instrument is the Confocal Scope then multiply the number of hours entered by 15. If it is a laser scope, it multiply the number of hours by 30. So I got a part of a formula…