Count if today and multiple criteria

Hello community,

My formula needs to read data from two columns with the combination of a CountIfs, Distinct, Today formula I think.

On row 16 in the count column, I want the cell to count how many entries are in the Amsterdam column when it is today's date. Row 2 shows today's date (16th March) and the formula should result in a count of 3. The 17th has 1 entry so should result in a count of 1.

If anyone has a solution, let me know!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!