count values

HI,

  • I have a form with checklist info for different types(Type 1 , Type 2), also in the form i specified minimum nr of selection for each types.
  • After submission i want to check whether submitted info has the valid nr of selection r not


  • Ex)For Type 1 person has to select minimum 1 checkbox
  • For Type 2 person has to select minimum 3 checkbox

After submission i want to count these checkboxs for type 1 and type2

if the person selected minium1 checkbox for type 1 then the type1count column has to show green

if the person selected minimum 3 checkbox for type 1 the type2count column has to show green

i am bit confused with the formulas , can anyone please

help me out


Answers

  • PYI
    PYI ✭✭

    =COUNTIFS(A@row:A@row, 1, B@row:B@row, 1)>0 ,"Green"

    i have tried something like this but it dint worked out

  • Hi @PYI

    You're close with your formula! However instead of having each column be its own range, you can create a range from A to B, like so:

    A@row:B@row

    Then you can look between these cells to see how many checked boxes there are:

    COUNTIF(A@row:B@row, 1)

    Based on the number you can display different options, such as "Green", but this would need to be in an IF Statement.

    Try something like this:

    =IF(COUNTIF(A@row:B@row, 1) > 0, "Green", "Red")


    You can do the same thing for your other columns, but I would change the order so if it's less than a number show Red, otherwise Green:

    =IF(COUNTIF(C@row:E@row, 1) < 3, "Red", "Green")


    Does that make sense? Let me know if this works for you!

    Cheers,

    Genevieve

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!