
Patrick_Ford1

6 - Interface Innovator
Comment Post Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
โMar 21, 2018
05:10 PM
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!
7 Comments