I would like to be able to set up a field that tells me what projects are on time for completion for that day. Ideally it would function like this:
IF(IS_BETWEEN(TODAY(), {Start Date}, {End Date}), ‘On Time’, ‘Late’)
The logical sentence would read: "If Today is in between Start Date and End Date, then “On Time”, if not, then “Late”.
There are tons of other things I could use it for as well. But as of right now, the formula is extremely long for what I’m doing it for. Please add this function! It would simplify my formulas so much!
... View more