Excel --> Smartsheet

Berkant

Hello world, I have to import KPI's from Excel to smartsheet, I know that I can import an Excel file, it's the first thing that I did. But for some columns, Smartsheet didn't took in account a fomula which is the following :
=SI(R12="";NA();SI(ESTNA(Q15);R14;R12+Q15))
(For info,my Excel is in French), I've tried to adapt the formula via ChatGPT but Smarsheet was only saying "unparseable".

Thanks for your help people.

Kerry St. Thomas

If appears you're specifically returning an #N/A error if R12 is empty. You may need to modify what's happening there. Also, as I understand it Smartsheet syntax uses a comma , as the separator instead of the semicolon ; for EU Excel as above. It also appears you're evaluating FOR an #N/A error; have you considered using ISERROR in Smartsheet?

Check this out for more info about using ISERROR:
https://help.smartsheet.com/function/iserror

Good luck!

Berkant

Hello, yes in EU we use ";" as separator. I didn't considerate using IFERROR, I'm going to try it right now.

Thanks Thomas.