Formula (if this is and date beyond, check flag)

Susan Swisher

Help with this formula (generated through AI). I need it to look at this cell (if it is blank) and another cell (date) is greater than 3 months, turn the FLAG on in ____ (cell). I am missing this other cell name, I believe. Cell/Field is called Protocol FLAG.

=IF(ISBLANK([DRAFT Protocol Received (Date)]@row) AND ([Notification (A/D) in Portal]@row < TODAY(-90)), 1, 0)

Susan Swisher

looks like it needed this:

=IF(AND(ISBLANK([DRAFT Protocol Received (Date)]@row), [Global Notification (A/D) in Portal]@row < TODAY(-90)), 1, 0)

Susan Swisher

So, back to my original question; this isn't working (at all), if I calculate the date/time manually. I don't understand the difference between (+90) (90) or (-90)

The formula looks at "DRAFT Protocol Received (Date)" (if it is BLANK); then it has to look at "Global Notification A/D)" and then determine, from that DATE (which is filled in), if it is more than 3 months (90) from TODAY, it will TURN the FLAG on in "Protocol Flag"

AravindGP

Hi @Susan Swisher

If you are trying to add a flag to the Protocol Flag column when Draft Protocol Received (Date) is blank and when Global notification A/D date is greater than 90 days from today, your formula should be =IF(AND(ISBLANK([DRAFT Protocol Received (Date)]@row, [Global Notification (A/D) in Portal]@row > TODAY(90)), 1, 0)

+90 or just 90 would mean 90 days in the future and -90 would mean 90 days in the past from today.

Note that in the formula, if the DRAFT Protocol Received (Date) has a value, the flag will remain unchecked as both of the conditions need to be met in order for the flag to be checked.

Susan Swisher

@AravindGP Thank you for the additional details and formula; unfortunately, I am getting an #incorrectargumentset error

AravindGP

Hi @Susan Swisher

Try this formula

=IF(AND(ISBLANK([DRAFT Protocol Received (Date)]@row), [Global Notification (A/D) in Portal]@row > TODAY(90), 1, 0)