I have a Deadline column (date) and a “Urgency” column in a sheet. I want any row/item due in less than or equal to two days to be marked in other column as Urgent, and I want anything longer than that to be marked as Not Urgent.
I’m guessing there’s a good formula for this, but I’ve poked around for a bit and haven’t been able to find one/do it myself.
Any help is much appreciated!!!