IF / THEN Formula help
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.