Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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))))
=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
