Welcome!

how to count/sum boolean data formula

Hello my firends! How have you been?

Would be possible to have a logical formula to checks whether a bollean range and than return that sum of them.

for example: if I got two lines with 4 stars the formula should identify into the range both lines and returns 2 as total

Hi Guilherme,

Try this.

=COUNTIF(Range:Range; ="Four")

The same version but with the below changes for your and others convenience.

=COUNTIF(Range:Range, ="Four")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Getting the Triggered by at least 5 other workflows but nothing is daisy chained
Hello, I'm seeing this error for the first time as I expand some capability in an existing workflow. Here's how this section with the error works. Scenario: a user puts in a request on the form with a check box indicating they will later upload the required file attachment. Automation sends a request for Approval with…
Re assign task midway thru
I have a task that started in Sept and ends in Feb. I need to assign it to someone else, but do not want to lose the history of the first employee. How do I do this?
Suddenly receiving multiple emails titled "Your Smartsheet Order has been Activated"
Starting a couple of days ago, I started getting 2 or more emails a day about my account being activated. I have a monthly subscription but have never received this type of email from Smartsheet. The email looks legitimate - the sender is "reply_to@Smartsheet .com" - except for maybe the greeting, which is "Dear Customer".…