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

SJ
SJ
edited 12/09/19 in Archived 2016 Posts

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

  • JamesR
    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
    Cbrannon
    edited 04/12/17

    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

     

  • JamesR
    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

     

This discussion has been closed.