I would like to create buckets of the numbers of days a case has been open. I have used Create Date and Today's date to get this number but need help creating a formula that displays the range.
If a case has been open less than 5 days then display "Less than 5 Days"
If a case has been open between 5-10 days then display "5-10 Days"
If a case has been open between 10-20 days then display "10-20 Days"
If a case has been open more than 20 days then display "20+ Days"
I have created an IF statement but it doesn't seem to work for all values. I have attached a sample.
Any help would be appreciated!
Bookmarks