Nested IF formula to return a value
I am trying to have one of four categories returned in a field field called Grouping (Values to return: Enterprise Project, Non-Enterprise Project, TBD - In Discovery, Tech Annual Initiative) based on the value in another field (Estimated Block Hours).
Here is the criteria in the Estimated Block Hours field for when to select the different categories in the Grouping field:
Enterprise Project: >= 80
Non-Enterprise Project: < 80
Tech Annual Initiative: TIA (could also have this be '0' if it needs to be a number)
TBD - In Discovery: Any other value or blank.
Here is my formula, but I can only get the Enterprise Project or Non-Enterprise Project to return the correct values:
=IF([Estimated Block Hours]1 < 80, "Non-Enterprise Project", IF([Estimated Block Hours]1 >= 80, "Enterprise Project", IF([Estimated Block Hours]1 = TIA, "Tech Annual Initiative", "TBD - In Discovery")))
Help Article Resources
Check out the Formula Handbook template!