Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula Help with NA
I need help with a formula. I have 3 date columns. If there's a date in datecol1, and a date in datecol2, and either a date or NA in datecol3, then enter 1 in col 4. I am not a programmer, but can usually figure it out. Not this time! This is what is in col 4 cell, but I get Unparseable.
=IF(ISDATE([datecol1]7), IF(ISDATE([datecol2]7), IF(OR(ISDATE([datecol3]7), ISTEXT([datecol3]7) = "NA"), 1)))
Appreciate any help!