IF Function
![Queenie Yap](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Hi All,
I copied an IF function to another sheet with identical column names. For some reason, the function no longer works. Does anyone know if there were changes to the IF Function. Here is the formula that I copied:
=IF([Start Date]3 < [Baseline Start]3, "red")
I got an "#Invalid Operation"
I submitted a help ticket but haven't gotten a reply. Does anyone here know?
Thanks.
Comments
-
Hi,
Have you double-checked the column types and names?
Here's more information about the error message.
#INVALID OPERATION
Cause
Operators (see Create and Edit Formulas for details on acceptable operators) in a formula aren't supported in Smartsheet or are mistyped. For example, this IF statement that returns the text "Low Stock" if a cell contains 25 or less...
=IF(Quantity1 =< 25, "Low Stock")
...has the "less than or equal" to operator in the wrong order; the correct order being <= to make the formula =IF(Quantity1 <= 25, "Low Stock")
Resolution
Check all operators to make sure they're not mistyped and are supported by Smartsheet. See Create and Edit Formulas for details on acceptable operators. The most common cause of this is typing <= (less than or equal to) and >= (greater than or equal to) operator combinations in the wrong order.
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you Andree for responding. Column type, column names and formulas are identical in both sheets. For some reason the formula doesn't work in the newer sheet. Just wondering if the programming was changes for the functions because there was an update done a few weeks ago.
Queenie
-
I have had this happen before as well. If you edit the formula in the new sheet (remove the row reference or delete the first letter of a column name or something) to "break" it, leave the cell, the edit the formula again to "fix" what you "broke", you should be good to go.
-
That's strange!
I'd be happy to take a look and see if I can see what's causing it.
Can you maybe share the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Yes, I agree with Paul!
If you haven’t already, I would recommend that you try to break/fix the formula.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
OK, I figured it out. Both columns need to be the same column type. One of the columns I had it as TEXT column when both columns need to be DATE columns. Thanks for everyone's comments.
Queenie
-
Glad you found the solution!
Happy to help!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Yep. That'll do it. Glad you were able to get it working.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!