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
Could tou please help me to count the nuber og checked rows in a sheets without making parent, children rows?
Hi (Hej),
You must add a so-called helper column that will check if the row is a parent or not and then use that in the formula that's counting the checkboxes.
Would that work?
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hi Andrée
Thank you so much for responding that quick :-D
I did not understand that. I think it is weird that you have to make help columns to count the number of checked boxes in a coulumn. I share the sheet with you.
I want to sum up the number of checked boxes i these two coulmns:
Gjennomgått HMS-ansvarlig and Lukket HMS ansvarlig.
Take a look at the photo :-D
I am going to use these values in a future dashboard.
Best regards
Stian
Happy to help!
I misunderstood your question. You don't need a helper column. I've added the information to your sheet.
Andrée
I am so happy thtat you can helpt me :-D
I am new to smartsheets, but I have already fallen in love with the program
I can see that you can not put the formula in the cell on the top of the respective column because it has the status as checbox?
Thanks again!
Hi All, I'm working on a formula that is evaluating three columns of data: 1) EOY Target Weighted MWh 2) Forecast Weighted MWh 3) Increase/Decrease (to determine if the goal for the year is to increase or decrease the MWh) Here is my current formula: =IF([Forecast Weighted MWh]@row = [EOY Target Weighted MWh]@row, "On…
I need the Date of Sample Shipment to start within 20 days of the Date of Manufacturing Start Date. However, the predecessor I have there isn't working properly. What should it be? Thank you so much
I am trying to find a way to look at text fields and automatically remove date and time stamps plus employee names. Any recommendations on identifying and removing text strings that meet the below formats: YYYY-MM-DD HH:MM:SS.SSSSSSS ####### [Employee Name] YYYY-MM-DD HH:MM:SS.SSSSSSS ####### [Employee Name] We have a…
