Metric Sheet Formula

Hi All,

I'm trying to write a formula to achieve the following:

In the source sheet: Check if the "Resource Type" column contains "Analytic/Data". If it does, it counts the occurrences where the "Deadline Health" column contains the value of the current cell in the "Description" column, otherwise, it returns an empty string. Any Ideas why this is not working?

=IF(CONTAINS({Resource Type}, "Analytic/Data"), COUNTIFS({Deadline Health}, CONTAINS({Description@row}, @cell)), "")

Thanks in advance!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!