Excel formula not working in Smartsheet

SJ

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))))

JamesR

=IF(L7="Not Applicable",K7,IF(OR(ISBLANK(K7),ISBLANK(L7)),"Pending",IF(K7>L7,K7,L7)))

Try that you had too many brackets

Cbrannon

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"," ")

Shaine Greenwood

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

 

JamesR

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