I just want to do a simple function IF formula but it isnt working
Sue08
✭
Hi
I have created the input in these cells via a result of a VLOOKUP formula and now I want to use this cell to create results in another cell via a simple IF formula.
If the cell finds "#NO MATCH" then return No and if not return Yes
Im currently using
and am getting the results in column 2
Hi
Dont worry I can see the bracket missing is the issue
Pls disregard this question for assistance
Answers
-
=IF(CONTAINS("match",[Frequency]@row),"No","Yes")
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!