Task completion (%)


Hello everyone,

is there a way to set the % complete based on the task status?

I have a table

[state ; % complete]

I tried with "VLOOKUP" function but isn't possible to insert formulas in the field.

Help me please!


Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer βœ“

    Hi @malanto,

    This is possible, but you would need to define the criteria.

    You would use a nested IF statement. A very basic example:

    Status % Complete

    Not Started 0

    In Progress 50

    Complete 100

    Would have the following formula in the % Complete column:

    =IF([Status]@row="Not Started",0,IF([Status]@row="In Progress",0.5,IF([Status]@row="Complete",1,"")))

    This assumes you've set the column to be %, otherwise you'd want to increase the numbers by 100 (0.5 to 50).

    Hopefully this gives you some ideas, but if you're still unsure or have any problems/questions then just ask! πŸ™‚


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!