how to use "<>N/A" formula in smartsheet Date column

Yashwant Singh
edited 07/09/20 in Formulas and Functions


using countif() formula for count total count of "<>N/A" cells. when use formula

=COUNTIF({Master Tax Calendar Range 3}, "<>N/A") and my count is zero. my column format is Date.

same formula count correctly in excel but not working in smartsheet.

please suggest formula for how to count total, if my date column contain "N/A"...



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!