IF / THEN Formula help

05/03/19 Edited 12/09/19

Hello,

Im quite new to Smartsheets and was hoping for some code assistance.

What i am trying to do is as follows:

1)  Search a column (column1) in another sheet for a value, say 5.

2)  When it finds that value, count how many checkbox's in column2 has been ticked

Im trying to use an IF([column1]=5, COUNTIF(column2),1),0) functionality but cannot seem to get it to parse.

Any advice would be appreciated.

thx

Andrew

Tags:

Comments

  • Andrew - 

    Use the COUNTIFS formula : 

    =COUNTIFS({Test Sheet 1 Range 1}, 5, {Test Sheet 1 Range 2}, 1)

    {Test Sheet 1 Range 1}, 5 - is counting when the value 5 is found in the first column.

    {Test Sheet 1 Range 2}, 1 - is counting when the checkbox is checked

    All criteria need to be met.

     

    Sean

    2019-05-03_15-55-03.jpg

    2019-05-03_16-02-29.jpg

  • Hey Sean,

    Thanks for that mate - appreciate the help!

    Andrew

Sign In or Register to comment.