Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

CountIF using AND


Hi all,

Can anyone tell me what might be wrong with this function below?

=COUNTIF((AND([Field CSA]:[Field CSA],"Name"),([Status]:[Status],"TEMP")))

I need to count the occurrences where the Field CSA column has the word Name and where the status column has the word TEMP. 

When each value appears in their respective columns on a given row, I need to count the occurrence of that on the sheet.

Thank you in advance for your help and assistance.




This discussion has been closed.