Trying to count how many cells have text in them which is a link to a project plan in other sheet

This is what I have started with:

=COUNTIFS({Prioritisation log - Forum Call Date}, >=[Start Date]1, {Prioritisation log - Forum Call Date}, <=[End Date]1, {Prioritisation log - Link to Project Plan} "text")

Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓

    Try this:

    =COUNTIFS({Prioritisation log - Forum Call Date}, >=[Start Date]1, {Prioritisation log - Forum Call Date}, <=[End Date]1, {Prioritisation log - Link to Project Plan}, ISTEXT(@cell))

    Use the ISTEXT function to check for any text value in a cell, and the @cell parameter performs a calculation on each row at the same time that the primary function (COUNTIFS) is evaluating the criteria in the range.

    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!