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

Options
edited 12/09/19

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

• ✭✭✭✭✭✭
Options

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

Try that you had too many brackets

• edited 04/12/17
Options

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

• Employee
Options

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

• ✭✭✭✭✭✭
Options

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

This discussion has been closed.