Excel --> Smartsheet
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.
Answers
-
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:
Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
Hello, yes in EU we use ";" as separator. I didn't considerate using IFERROR, I'm going to try it right now.
Thanks Thomas.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!