Aug 03 2021 12:47 PM - edited Aug 03 2021 12:47 PM
Hi!
I have the following data: ID, order #, submission date, price, submitted by, case.
I want to get all orders that are submitted today (column c), then check their case (column h), then count orders, which have their case set to "1".