Formula Containing Two Separate Column Results
I am attempting to create a Smartsheet Summary field that contains a formula that provides the count of the number of risks I have in the risk column of a sheet combined with a status of not closed in a subsequent status column. This is the formula I have written but it is returning a parsing error:
=COUNTIF([Risk or Issue]:[Risk or Issue], ="Risk", [Status]:[Status], <>"Closed")
Any insight would be helpful.
Thank you in advance.
Help Article Resources
Check out the Formula Handbook template!