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.

IF Statement searching for dates

Faith Glass-Wilson
Faith Glass-Wilson ✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

Hello All,


I'm trying to figure out why my Excel formula won't work in Smartsheets and what I need to do to fix it. I want Column B to return the corresponing date for the stage listed in Column A.


My formula that is working in Excel is: =IF(A2="SC",C2,IF(A2="FC",D2,"TBD"))


And looks like this in Excel:

Stage (Column A)Date (Column B)SC (Column C)FC (Column D)


But the same formula won't work in Smartsheets. What do I do?


This discussion has been closed.