Struggling with COUNTIFS


=COUNTIFS(Status:Status, "Received" AND([ETA/Receipt Date]>=TODAY(-30)),[Merchandising Review - Rebecca]:[Merchandising Review - Rebecca], "Yes")

trying to add a stipulation here where status is Received but the actual date must be greater than past 30 days

keep getting #unparseable

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!