I've used the nested if formula a number of times, but can I get it to work for this one? Nope!
I have a single select dropdown column with statements. In another column, I want the statement to return a different text value. The only time it works is when the first option (first IF statement) is selected. Could it be that the statements are too long?
=IF(Priority@row = "There is risk if we do not deliver or is a regulatory requirement", "Highest", =IF(Priority@row = "Will advance a specific strategic directive or addresses significant barriers to operations", "High", =IF(Priority@row = "Important to advancing our strategy or sets the foundation for future work", "Medium", =IF(Priority@row = "Addresses gaps or pain points that would add value but not urgent", "Low", =IF(Priority@row = "Work has potential but can wait to be actioned until other work is complete", "Lowest")))))
