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
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||SC (Column C)||FC (Column D)|
But the same formula won't work in Smartsheets. What do I do?