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.

Needing an "If, Than" formula for multiple variables

edited 12/09/19 in Archived 2017 Posts

I am pulling together stats for a project using the JIRA connector and I need to be able to SUM all "Open" issues + "Reviewed" issues into one cell.  I have the beginning of the statement and it works just fine, but whatever I tried to add the last part, "Reviewed" I get an unparseable error.  Here is what I have:

=COUNTIF(Status6:Status20, "Open")



This discussion has been closed.