IF / THEN Formula help

AndrewWalter

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

sean59916

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

AndrewWalter

Hey Sean,

Thanks for that mate - appreciate the help!

Andrew