Matching a Name to another sheet and is checking a row if it is a date

Paul Mangan
Paul Mangan ✭✭
edited 05/15/24 in Formulas and Functions

=IF(AND(MATCH([Team Member]@row, {Team Member}, 0), ISDATE({L1 Mixer})), 1, "")

This is what I try and it returns incorrect argument set on the first row, but invalid data type on the remainder. It is a column formula.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!