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

Janet757
Janet757 ✭✭✭
edited 12/09/19 in Archived 2015 Posts

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!

Thanks, Janet

Tags:

Comments

This discussion has been closed.