Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
My IF statement isn't importing from excel and can't figure out why
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)
Answers
-
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.
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.2K Get Help
- 455 Global Discussions
- 155 Industry Talk
- 505 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I need a formula to calculate sets of specific Date columns, and tally those date columns into a % of that set? For e.g. I have 2 groups. Each group has specific columns that make up the set for each …
- How do I edit this formula to turn button yellow when due date is 5 days away. =IF([% Complete]@row = 1, "Green", IF([End Date]@row < TODAY(), "Red", IF([End Date]@row = TODAY(), "Yellow", "Green"))) …
- Hi, in the image below I have in my "extrusion" column an entry that populates by a formula (in this case "M3406 HEAD TRACK 15' is populating) I'm looking to populate the "Last Cycle Count Date" colum…