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

Amanda O

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")

Jeff Reisman

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.

Jeff Reisman

@Amanda O

Are you looking to literally match the word "text," trying to match some other singular text value, or just trying to check if the cell has any text value in it (vs blank, number, date, etc.)?

Amanda O

Hi Jeff

Yes I am looking to see if any cell has any text value in it

Thanks

Jeff Reisman

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.

Amanda O

https://community.smartsheet.com/discussion/comment/321337#Comment_321337

Thank you so much Jeff that has worked:-)

Amanda