Skip to Main Content

Share your product feedback

Status Future consideration
Categories Reports
Created by Guest
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