Sign in to join the conversation:
Please , is there a way to count how many starts from a checkbox I have (per cell)?
Hi Guilherme,
Try this.
=IF(Stars@row = "Empty"; 0; IF(Stars@row = "One"; 1; IF(Stars@row = "Two"; 2; IF(Stars@row = "Three"; 3; IF(Stars@row = "Four"; 4; IF(Stars@row = "Five"; 5))))))
The same version but with the below changes for your and others convenience.
=IF(Stars@row = "Empty", 0, IF(Stars@row = "One", 1, IF(Stars@row = "Two", 2, IF(Stars@row = "Three", 3, IF(Stars@row = "Four", 4, IF(Stars@row = "Five", 5))))))
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Thats a lot Andrée! Make my day happier!
Happy to help and make you happier!
Have a fantastic weekend!
Andrée
I have tried to set them as Edit - can share, Edit - cannot share, and commenter and nothing works, they cannot add data to the sheet. Does anyone have a solution?
The Issue My project-specific metadata sheets use INDEX/MATCH formulas that reference the Intake sheet using a Project ID. When the automation archives rows from the Intake sheet, these formulas break because they can no longer locate the source data. Example formula: =INDEX({Project Intake Name}, MATCH([Project ID 1]@row,…
Two of my five automation workflows appear to have just randomly stopped performing on April 9, 2026. All others, which would/are performing as normal and would be functioning alongside the other workflows, are functional and appear to be untouched by this 'bug'. Help I've tried all that I can think of.
