What is the challenge? |
Rather than requiring use of multi-nested "IF" statements, calculated columns should support more than just exact match, e.g. switch(field("Days Overdue") , >7 , "2 - Very late" , >1 , "1 - Late" , "0 - On Time") |
What is the impact? |
Simpler formulas |
Describe your idea |
switch(field("Days Overdue") , >7 , "2 - Very late" , >1 , "1 - Late" , "0 - On Time") |