# Grouping Field Data

• 0
• Question
• Updated 2 years ago
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?
• 346 Points

Posted 2 years ago

• 0
• 31,698 Points
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",
"")))