Sheet Summary Formula to count check box

Melanie Sanders ✭✭✭✭✭

06/12/24 in Smartsheet Basics

Hello, I am having a hard time setting up this formula in Sheet Summary

=COUNTIF([Account is Ready]:[Account is Ready], "ischecked")

Can you help.

0 · Share on FacebookShare on Twitter

Best Answer

• 

  Vince Darrigo ✭✭✭✭

  06/12/24 Answer ✓

  Hi @Melanie Sanders I think you just need to replace that ischecked with a 1:

  =COUNTIF([Account Is Ready]:[Account Is Ready], 1)

  I hope this helps!

  

  1 · Share on FacebookShare on Twitter

Answers

• 

  Peggy Parchert Community Champion

  06/12/24

  Hello @Melanie Sanders

  try this:

  =COUNTIF([Account is Ready]:[Account is Ready], 1)

  Hope it helps.

  Peggy

  0 · Share on FacebookShare on Twitter
• 

  Vince Darrigo ✭✭✭✭

  06/12/24 Answer ✓

  Hi @Melanie Sanders I think you just need to replace that ischecked with a 1:

  =COUNTIF([Account Is Ready]:[Account Is Ready], 1)

  I hope this helps!

  

  1 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet