How am I using this Formula wrong?

Himjamin
Himjamin ✭
edited 05/30/24 in Formulas and Functions
image.png

I get a "#INVALID COLUMN VALUE" error from this formula.

Tags:
· Share on FacebookShare on Twitter

Best Answer

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    edited 05/30/24 Answer ✓

    @Himjamin

    The Has() as well as the Contains() Functions have to be used as part of another Formula. As It only returns True or False. So instead try

    =IF(Has(Testing1:Testing13,13),"Value you want it to return if True","Value you want it to return if False")

    If you omit the False portion of the formula it will return a blank.

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

    · Share on FacebookShare on Twitter

Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    edited 05/30/24 Answer ✓

    @Himjamin

    The Has() as well as the Contains() Functions have to be used as part of another Formula. As It only returns True or False. So instead try

    =IF(Has(Testing1:Testing13,13),"Value you want it to return if True","Value you want it to return if False")

    If you omit the False portion of the formula it will return a blank.

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!