IF statement where condition is within value range

Avatar
Sarah Kibart

Hi, 

We created the following formula to show the number of projects where the SLA (a custom field populated in days) was overdue by one day:

SUM([Project ID],IF([Total Task Duration (days)]-[Average SLA]=1,1,0))

we then duplicated the formula, changing =1 to =2, =3 etc to show 2 days overdue, 3 days overdue etc. 

However, we're unsure of the formula if we wanted to group the number of days e.g. IF([Total Task Duration (days)]-[Average SLA] is greater than or equal to 5 but less than 10 (showing the total number of projects that were between 5 and 9 days overdue). 

Any help would be appreciated :) 

 

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
1 comment
Avatar
Juan

Hi Sarah Kibart, welcome to the Community! I've created a ticket with our Support Team on your behalf; one of our experts will reach out to you shortly to assist you with this 👍

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: IF statement where condition is within value range
[this list is visible for admins and agents only]

Top
Didn’t find what you were looking for? Write new post