My IF statement isn't importing from excel and can't figure out why

thilmas

I have what I think is a fairly simple nested if statement that isn't importing into Smartsheet, it just shows blank and I can't figure out the issue. The excel formula is: =IF(ISNUMBER(C2),
IF(AND(ISBLANK(X2), ISBLANK(Y2)), TODAY() - C2 + 1,
IF(AND(ISNUMBER(X2), ISBLANK(Y2)), X2 - C2 + 1,
IF(AND(ISNUMBER(X2), ISNUMBER(Y2)), (X2 - C2 + 1) + (TODAY() - Y2 + 1),
"Invalid Data"))))

Why can't I get it to import? (These are dates I'm working with)

Melissa Yamada

Hello @thilmas

Due to formula syntax differences between Excel and Smartsheet, imported Excel formulas might not function in Smartsheet.

To work around this, store the source sheet formulas as text by removing the equal sign before the formula and then save the sheet. Once in Smartsheet, you can add the equal sign back and modify the syntax to make the formula work.

https://help.smartsheet.com/articles/504553-import-files-to-create-new-sheets