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
-
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
-
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.)?
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!
-
Hi Jeff
Yes I am looking to see if any cell has any text value in it
Thanks
-
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!
-
Thank you so much Jeff that has worked:-)
Amanda
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!