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
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
