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
✭✭✭✭
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?
Comments
-
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
This discussion has been closed.
