Nested if helper column to set project size

Henry L.

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

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

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

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

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

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