Sign in to join the conversation:
Hi,
I need suggestions on how to count string of text on a column. For example, i need to count how may GRC are there on the sample below:
GRC
Aer, GRC
Aer, CDIR, GRC
HTM
etc.
Thank you!
=COUNTIF([Column1]:[Column1], FIND("GRC", @cell) > 0)
Awesome! thank you for saving me the trouble!
Follow up question; if I find "GRC" in the above example and wanted to automatically check a checkbox column, what would the formula be?
Just a simple if statement inside of the checkbox.
If([Output from previous formula]1>0,1,0)
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
Hello, I use Smartsheets in a Higher Education setting. I have one sheet (Sheet A) for a list of students this sheet contains their student id numbers, email addresses, as well as other helpful information. I built a If Yes/If No check column on this sheet as well. My next sheet (sheet B) is a form that is asking is the…
