Nested if helper column to set project size
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.
Help Article Resources
Check out the Formula Handbook template!