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

Options
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)
SC01/01/1701/01/1709/01/18
FC12/07/1804/05/1712/07/18
 TBD06/12/1707/07/18

 

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

Comments

This discussion has been closed.