Formula to update a cell

Options

I want my column for progress (Not started - In progress - Complete) to update when someone adds the % complete. So is "0" then read "Not Started", If < the 0 but not 100% then "In Progress" and if 100% then "Complete". Does anyone know that formula?

Tags:

• Options

Hi Terry,

Let suppose you have a column "%" which is your input and a column "Status" where is your formula.

The formula to enter would be someting like:

=IF(ISBLANK([%]1), "", IF([%]1 = 0, "Not Started", IF([%]1 < 100, "In Progress", "Completed")))

Hope this helps. Have a nice day!

Mathieu @evolytion

Mathieu | Workflow Consultant

info@evolytion.com

• ✭✭✭✭✭✭
Options

You'll need to change the < 100 to < 1 for it to work with a percentage formatted column.

Smartsheet looks at the numbers in a column formatted for percentage as values between 0 and 1. You'd need to use decimal values instead for it to work

25% = 0,25 (0.25)

50% = 0,5 (0.5)

100% = 1

Depending on your country/region, you'll need to exchange the comma to a period.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!