Sheet Summary Count level under a particular parent Row

Options

Hello Experts,

i'm trying to make sheet summary for the Row under a particular parent:

i have a smart sheet that has values in a column, date in another column

1) count the row only under a "Particular Parent"

2) Count if there is any value is provided, and

3) Year is 2020

i used this formula in sheet summary =IF(COUNT([Shop Order]3:[Shop Order]44) > 0, COUNTIFS([To Test]3:[To Test]44, IFERROR(YEAR(@cell), 0) = 2020)) seems this not considering certeria 2

please advise.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!