I want to create a column that indicates # complete a task should be per the start and finish dates. This will allow the user to compare expected vs actual % complete. I have a helper column already that does this for the Risk Flag formula, but it can actually go below or above 0-100% depending on when the start and finish dates fall in comparison to current day. O only need 0-100%.

For projected % complete, you would use something like this: =MAX(MIN((TODAY() - [Target Start Date]@row) / ([Target Finish Date]@row - [Target Start Date]@row), 1), 0)

You have one too many closing parenthesis after the today function, two too many after the duration@row, and it look like you have the end mixed up a little bit. Duration@row, 0), 1)), "")

Sorry. I'm on my phone right now and didn't realize I got the end mixed up in my last post. Switch the one and zero at the end.

Create a column that indicates # complete a task should be per the start and finish dates.

Answers

Paul Newcome ✭✭✭✭✭✭

09/08/23

Happy to help. 👍️

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Within the last 12 months
I can't get my formula to pull violations reported only within the last 12 months. Can someone see what I am missing? =COUNTIFS({Compliance Master File V2 EE-number}, [EE Number]@row, {Compliance Master File - Compliance Category}, "Reinstatement"), AND({Compliance Master File V2 Violation Date}<=[Today]@row, @{Compliance…
IFERROR and january dates for previous month (and Year)
Happy New Year All. I have successfully had help in navigating the problems of "Previus" month when a new year like now for both COUNTIFS and SUMIFS However, I have a simple IF statement and just cannot get it to work. 4 fields Date & Time - this is the automated date creation value This Month - dropdown with True or False…
Match Multi Values to a Table?
Hello, I am trying to figure out how to VLOOKUP or MATCH or something else to return values from a table. In the example below, in the highlighted row, I would want it to return the three highlighted 'Assigned To' values in the table below. Is this possible? Or is there a better solution that I am not thinking of?

Create a column that indicates # complete a task should be per the start and finish dates.

Answers

Help Article Resources

Categories