I am building a very robust task list for my team and would like to tag cells in a column based on words rather than just color.
So, I have two columns. DUE DATE and STATUS.
I would like to create a formula that looks at the DUE DATE and determines if the date is TODAY, TOMORROW, THIS WEEK, NEXT WEEK and fill in the STATUS cell with one of those words.
Then I will create a BY DUE DATE view grouping it by those words. It will be just like the latest software out there!
Hope this makes sense.