Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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 have an Action Log and in the log we have a column that identifies the different projects our team leads. There is also a Workstream column, which identifies what workstream is responsible for getting the answer. There can be more than one answer, so we have a dropdown and if multiple workstreams are responsible for the…
So here what I'm trying, I have multiple solution and status for all. Trying to get the total net worth value of order based on solution + individual status. Let's say I want to capture the total revenue for Centralised Inventory with all different status as below: I tried with Sumifs but it's not calculating all values.…
I would love some help troubleshooting a column link issue between two sheets used for department metric scorecards. Sheet 1 (source sheet) is the metric submission sheet where metric owners report quarterly data. Sheet 2 (target sheet) is the scorecard that shows quarterly goals and actuals, with a status symbol for each…
