Grouping Field Data

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have a field to calculate no. of week days but would like to group Duration into different categories i.e <10 days, 11 to 15 days, 20 days. How do i go about doing so?
Photo of Dyn

Dyn

  • 346 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Official Response
Dyn, 

I apologize for that earlier comment, i made a few mistakes in it, it must have been distracted prat way through.

You need to make sure there are [brackets] around your duration field. 
[my duration field]
E21 looks more like an equation from excel.
If, then formulas in quickbase are structured the same as most If( condition , result if true, result if false)

You can daisy chain many if statements together, by not putting a result if false,  and replace it with the next IF statement. 

If([My duration field]=value, "text if true", If([My duration field]=value, "text if true", ""))
just make sure your parentheses all match up.

Try this for you:

If([Duration field]<=Days(10), "10 or less working days",
If([Duration field]>10 AND [Duration field]<=Days(30), "11-30 working days",
If([Duration field]>Days(30), "more than 30 working days",
"")))