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 am looking for a solution that woul d create a unique identifier for my row. I am using a index match formula to pull through needed fields, however the items that I am matching often have the same names on the reference sheet. I cannot adjust the names, but I would like to build a column that is unique to each row.
I have 3 columns in one row and I'm trying to show the average of the percentage of work done from those three columns. I've attached a screen shot. In one example, 25% is done from one column and 0% is done from the other two columns. The sum/average shows 54% complete In the next example I actually made all 3 columns…
I have two sheets, one is titled "Test Scenarios", it's a sheet that contains steps to complete a test scenario, the other is titled "Test Issues", it collects testing issues submitted via form URL. When a test scenario fails, the user selects "failed" from a multi select box which causes a form URL to display. The URL…
