Hello, I am trying to setup a data base for vechicle management, to facilitate followup on different issues depending on a deadline. What I need is it to return a value as it follows:
Deadline overdue = Overdue
Deadline between 0-10 days = Urgent
Deadline between 10-15 days= Soon
I created a column for calculating the no. of days to the deadline and used the following formula but it works only for the first two criteria:
Thankyou in advance!