Skip to Main Content
Categories Reports
Created by Brittani Carmandi-Weber
Created on Sep 18, 2024

Calculated columns should support more than an exact match

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")

  • Attach files