looking for help with a formula that uses one "text", and one "match" or "has" condition.


the closest I have gotten to getting some results is using: =IF(AND(CONTAINS("Q8", {Expenditure Report Collection Range1}), HAS({Expenditure Report Collection Range 2}, [Primary Column]@row)), "ok","missing")

maybe I don't understand order of operations but it's giving me a "ok" on a cell that should be missing. I need to use "Q8" text because the range has different drop-down selections with words and numbers. The other criteria is if it matches a number in the range, but I cant seem to get a "match" formula to work. HAS is providing some results.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!