Hi, I’m trying to automate a “status/priority” field based on “start/end date” fields - assigning one of the following options to every record:
NOWNEXTLATERDONE
I was able to create an IF-formula for 3 of the 4 options:
IF(Start <= TODAY(), IF(End >=...
Think I got one step closer by creating a new field that calculates the amount of days between TODAY and all LATER start dates. Now I just need a way to mark the lowest number as NEXT. Any thoughts?
Ultimately, I’d like to setup a kanban-view with four stacks (NOW/NEXT/LATER/DONE) instead so I can have a complete, yet compact overview. Hence I need to find a way to indicate which record comes right after NOW, so I can mark it as NEXT and prefer ...
Sorry if I’m not describing it well. I’ll try giving an example of what I’d like to accomplish:
Start: 1/1/2019 - End: 7/1/2019 = DONEStart: 15/1/2019 - End: 7/2/2019 = NOWStart: 14/2/2019 - End: 20/2/2019 = NEXTStart: 1/3/2019 - End: 7/3/2019 = LATE...
Normally it’ll be a single record, yes - namely a single trip/travel - but it could be there are more trips in one day, so they’d all have to be marked as NEXT unless I would use TIME as well as DATE.
Thought about this option as well since I’ve used it to organize my task list but doesn’t really work in this case. I’m trying to automatically order my trips/travels, so I can easily see what my “NEXT” trip is and which trips come “LATER” this year....
