Symbol Formula

Good morning, I am inquiring about a formula that adds a quantity of certain symbols within a sheet. I would like the total of check marks to be added. Attached is a screenshot of what I have unsuccessfully attempted thus far. Please let me know what changes are needed. Thank you

Screen Shot 2019-02-04 at 10.44.17 AM.png

Find more posts tagged with

Formulas

Comments

Andrée Starå

Hi Trevor,

If you want to count how many days that are "Yes" you don't need the ,1,0" at the end of the formula.

Try removing it, and it should work.

Try this instead, and you don't have to think about row numbers.

=COUNTIF(Monday@row:Sunday@row,"Yes")

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Trevor Phelps

Thank you for the prompt reply. This formula worked perfectly for me

Andrée Starå

Great!

Happy to help!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet Countdown Timer
Happy Thursday. I know many have asked this question before, but does anyone know of a way to have a column actively countdown time? Even if a plugin is needed, it will be considered. Here is what I'm looking to do. When a form is filled out and a new line is added to the sheet, I'd like the "Countdown Timer" column to…
INCORRECT ARGUMENT SET on an =IF function
I'm trying to pull in the contact information of a second HR Business Partner, contingent on the department of the individual, from a separate reference sheet. However, not all departments have a second HRBP— so if the column of "second HRBP contact info" is blank, I don't want anything to be pulled into the new sheet's…
Automation not triggering when % Complete shows '100% instead of 100%
I have an automation set up so that when the Status column changes to Complete, Canceled, or Not Needed, Smartsheet automatically updates the % Complete column to 100% (Text/Number column type). After that, another workflow should trigger to alert the next person that their task is ready. This worked fine before, but…