IF AND Formula for 5 Options
Hey Community, please help me figure this out.
We have 5 options for types of projects and they are the following:
Technical Services Projects
Technical Services Programs
We are trying to output one of those five options based on the columns Project Type and Program Type.
Project type can be either Technical Services Projects or Enterprise Projects, while Program Type can be either Technical Services Programs or Enterprise Programs. The last option (assuming this would be the false part of the IF statement) is ODE.
See picture below to get an idea of the columns, we are trying to output it in the OPPTY Type Master column (ignore the red row).
Any help on this is greatly appreciated!!
Help Article Resources
Check out the Formula Handbook template!