Nesting IF Statements to provide % Complete

Hello All,

I have a project sheet with the following status dropdown:

Not Started

In Progress

Ready for Review

Complete

Canceled

On Hold

Not Applicable

I'd like to write a nested IF statement to provide a value in a percent complete column. I've tried the following but get a #UNPARSEABLE response.

=IF(Status@row = "Not Started",0, IF(Status@row = "Complete",100,)

I've tried many variations of the following, but can't seem to get it. Thanks for the help

Tags:

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Hey @Alex Knisely

    Typically, %Complete columns are formatted as percents, which means 100%=1, not 100.

    If you give us the rest of your percentages, we can help you more specifically build your formula.

    =IF(Status@row = "Not Started",0, IF(Status@row = "Complete",1))

    Kelly

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!