COLLECT criteria Date is NOT Blank


=COUNT(COLLECT({ContractPayments Range 3}, {ContractPayments Range 1}, Agreement@row))

Above formula works fine, but I want to add another criteria to it where I check if a Date column value exists. I tried below variations, but both do not yield correct answers.

=COUNT(COLLECT({ContractPayments Range 3}, {ContractPayments Range 1}, Agreement@row, ISDATE({ContractPayments Range 2}),TRUE))

=COUNT(COLLECT({ContractPayments Range 3}, {ContractPayments Range 1}, Agreement@row, ISBLANK({ContractPayments Range 2}),FALSE))

For a second requirement, when I change the COUNT to SUM - it gives a #INCORRECT ARGUMENT SET error.

How can I add a data criteria which checks a data value has been inserted ?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!