Help with a Formula

Options

Hello, I need help creating a formula within a cell.

If the Review Status is Approved AND the Original Workflow Session Date is today and/or in the past then the % complete should turn to 100%.

If the Review Status is Approved AND the Original Workflow Session Date is in the future the % Complete should stay at 0%.

If the Review Status is Member Review Needed, the Original Workflow Session Date doesn't matter, and the % Complete should stay at 0%.

If the Review Status is Follow-Up Needed, the Original Workflow Session Date doesn't matter, and the % Complete should stay at 0%.

If the Review Status is Executive Service Agreement, the Original Workflow Session Date doesn't matter, and the % Complete should change to 100%.

If the Review Status is Not Needed, the Original Workflow Session Date doesn't matter, and the % Complete should change to 100%.

The two different options in the % Complete section is 100% and 0%.

The image below shows the examples of status's, dates and % Complete:

I currently have this set as an Automation Workflow but would love if it could be a formula within the cell, if possible.

Thank you!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!