IF Statement searching for dates

Faith Glass-Wilson

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	SC (Column C)	FC (Column D)
SC	01/01/17	01/01/17	09/01/18
FC	12/07/18	04/05/17	12/07/18
	TBD	06/12/17	07/07/18

 

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

J. Craig Williams

Here's the reference for the IF function:

 

https://help.smartsheet.com/articles/775363-using-formulas#if

 

and here's the article on cell referencing:

 

https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet#reference

 

Those should get you started.

 

Craig