Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Excel formula not working in Smartsheet
I would like to get the equivalent of the below formula working in my smartsheet. It is currently erroring:
=IF(L7="Not Applicable",K7,(IF(OR(ISBLANK(K7),ISBLANK(L7)),"Pending",IF(K7>L7,K7,L7))))
Comments
-
=IF(L7="Not Applicable",K7,IF(OR(ISBLANK(K7),ISBLANK(L7)),"Pending",IF(K7>L7,K7,L7)))
Try that you had too many brackets
-
Trying to see why this formula will work in excel but not smartsheet...
Thank you for any suggestions
=IF(ISNUMBER(SEARCH("Clay",[Company Name]1)),"Email Evelyn & Sabrina"," ")
-
Smartsheet and Excel are different—there are a few functions that won't in Smartsheet because the application doesn't have them yet. SEARCH() is a function available to Excel, but not to Smartsheet.
I'd recommend going through our functions list to see how you might supplement what you're looking for with a different function, such as FIND() or SUBSTITUTE()
Functions List: https://help.smartsheet.com/articles/775363-using-formulas
-
As Shaine says Excel and Smartsheet are Differents.
1 - Smartsheet cannot Reference External data (Vlookups etc) except by Linking or Data Mesh
2 - Smartsheet has less than 100 Formula, Excel has in excess or 300
3 - Smartsheet is a Multi user environment, Excel is not
4 - Smartsheet is a Collaboration environment, Excel tries to be
5 - Smartsheet is a Project/Task management tool, Excel is not
Horses for courses - Use the right tool for the job and integrate where possible
