Translate excel formula into Smartsheet
How can I translate this formula to Smartsheet?
=IF(ISNUMBER(SEARCH("vPGW",A1)),"vPGW", IF(ISNUMBER(SEARCH("smf",A1)),"SMF", ""))
Thanks
Tags:
Best Answer
-
Try this:
=IF(CONTAINS("vPGW",A1),"vPGW", IF(CONTAINS("smf",A1),"SMF", ""))
Answers
-
Try this:
=IF(CONTAINS("vPGW",A1),"vPGW", IF(CONTAINS("smf",A1),"SMF", ""))
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
