Flag based on blank column formula help

Jlaustse

I am trying to create a formula where a column will flag if another column is still blank 2 days after a date.

Essentially, if column named "Disposition after Phone Meeting" is still blank 2 days after date column "Initial Phone Meeting" date, then flag.

Thoughts? Thank you so much!!

Danielle O'Connell

My assumption is you have a column setup with Symbol - Flags for this response. Here is a formula that should work if you put it in the flag column:

=IF(AND(NETDAYS([Initial Phone Meeting]@row, TODAY()) > 2, ISBLANK([Disposition after Phone Meeting]@row)), 1, 0)

Jlaustse

Hi Danielle! I do have a symbol column set up -- when I enter that formula into it, it's still coming back with #INVALID.

Paul Newcome

#INVALID what? There are a few errors that start with invalid.