Nested if helper column to set project size


Hi all,

I am trying to create a nested if statement to set the project size to Small, Medium, or Large based on the estimated number of hours that project will take. This is what I have:

=IF([Est Effort (Total Hrs)]@row = "30-120 (2-3 weeks)", "Small", IF([Est Effort (Total Hrs)@row = "120-320 (1-3 months)", "Medium", IF([Est Effort (Total Hrs)@row = ">320 (>3months)", "Large", 0)))

Not sure if I am missing something here, appreciate any help.

Best Answer

  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭
    Answer ✓

    @Henry L. You are missing at least two closing brackets on column names:

    When you build a formula, if all the column names don't light up you have a syntax issue. You probably want to avoid column names with round brackets.

    Your logic seems sound, fixing the syntax will help.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!