to count the priority star from a checkbox

Guilherme Ribeiro

Please , is there a way to count how many starts from a checkbox I have (per cell)? 

Andrée Starå

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

Guilherme Ribeiro

Thats a lot Andrée! Make my day happier!  

Andrée Starå

Happy to help and make you happier!

Have a fantastic weekend!

Best,

Andrée