IF / THEN Formula help

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

Find more posts tagged with

Formulas

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

Hey Sean,

Thanks for that mate - appreciate the help!

Andrew

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…