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
-
@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
Answers
-
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?
-
@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
-
Thanks, that was it. You're right, all these brackets and parenthesis get confusing.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!