IF(FIND Function with OR

BTMarketingOps
BTMarketingOps ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I am trying to build a formula that searches in a column for a certain word using the IF(FIND formula but I would like to add in an OR to that. So I would like to use this function: =IF(FIND("Design", [Project Description]4) > 0, [Estimated Hours:]4, "") which works great, but add in other words such as Graphics to it. So the formula would search for the word design or the word graphics and if it finds it, then return the data from the Estimated Hours column. I cannot seem to get it right so including the formula that I know does work, but asking how I would build an OR to this formula. 

 

Thank you!

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!