Using COUNTIF(CONTAINS( referencing another sheet.

clarkej
clarkej ✭
in Formulas and Functions

Good morning,

I would like to write a formula that counts the instances where the text "Monday" appears in a given range.

I've tried:

=COUNTIF(CONTAINS("Monday", {Waitlist Range 2})) and some others that escape me now, but to no avail. The above function returns "Incorrect Argument".

Any help would be greatly appreciated.

Thank you.

· Share on FacebookShare on Twitter

Best Answer

  • Mark.poole
    Mark.poole Community Champion
    Answer ✓

    @clarkej

    =COUNTIF({Waitlist Range2}, CONTAINS("Monday", @cell))

    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

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!