Flag formula?

Becky Greenbury

Trying to use flag column...if date is within 3 days = flag, if not, or blank = no action. Below is the formula that is not working. What am I doing wrong?

=IF (ISBLANK([Submit by]@row)), 0, =IF([Submit by]@row <= TODAY(+3)), 1

Thanks!

Kelly Moore

Hey @Becky Greenbury

The parentheses in the formula are closing off too soon and not allowing the formula to execute.

Try this

=IF(ISDATE([Submit by]@row), IF([Submit by]@row <= TODAY(3), 1))

Is it ok that the flag stays lit if the [Submit by] was yesterday, or last week, or last year, etc? The formula says ON if it's TODAY+3 or less.

If you wanted the flag to only be on for Today up to Today(3) then use this formula instead

=IF(ISDATE([Submit by]@row), IF(AND([Submit by]@row <= TODAY(3), [Submit by]@row > TODAY(-1)), 1))

cheers,

Kelly Moore

Hey @Becky Greenbury

The parentheses in the formula are closing off too soon and not allowing the formula to execute.

Try this

=IF(ISDATE([Submit by]@row), IF([Submit by]@row <= TODAY(3), 1))

Is it ok that the flag stays lit if the [Submit by] was yesterday, or last week, or last year, etc? The formula says ON if it's TODAY+3 or less.

If you wanted the flag to only be on for Today up to Today(3) then use this formula instead

=IF(ISDATE([Submit by]@row), IF(AND([Submit by]@row <= TODAY(3), [Submit by]@row > TODAY(-1)), 1))

cheers,

Becky Greenbury

Perfect, that did it. Thank you so much!