Hi, I’m trying to create a formula that will take various job titles and assign them a more general role based on what their specific title is. I can get the formula to work when its just a single IF statement, but trying to nest many options is beyond me…as I don’t really have much experience with…

@rbichener , Even in the best of situations nested IF functions can be difficult. For you use case I would recommend using the SWITCH() function instead. For what you gave, this is how that would look: SWITCH({Position}, "Lab Manager", "Manager", "Area Supervisor", "Manager", "Senior Site Technicia…

monday Community Forum

If Formula nesting

Platform discussions Special workflows & use cases

rbichener (Ross Bichener) September 14, 2021, 9:55am 3

Works perfectly, thanks!

Topic		Replies	Views
Formula Help, If field = this, multiply other fields Platform discussions formula	14	5415	February 19, 2021
Nest IF Statements Platform discussions formula	5	4215	June 21, 2021
Can the SWITCH formula do number compares? Special workflows & use cases formula	3	2006	July 18, 2022
Building Complex Formula Special workflows & use cases formula	1	1224	January 7, 2023
Nested IF Formula -> Dropdown menu Special workflows & use cases formula	4	58	October 7, 2024