Nested if helper column to set project size

Henry L. · 10/03/22

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.

Dale Murphy · 10/03/22

@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.

Cheers,

dm

Henry L. · 10/03/22

To add to this post: I am trying to use terms from a dropdown column. Does this work or would I have to use Text/Number?

Dale Murphy · 10/03/22

@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.

Cheers,

dm

Henry L. · 10/03/22

https://community.smartsheet.com/discussion/comment/345755#Comment_345755

Thanks, that was it. You're right, all these brackets and parenthesis get confusing.

Nested if helper column to set project size

Best Answer

Answers

Help Article Resources

Categories