Counting Functions


I'm using this formula to calculate the number of inquiries received versus those who have not yet been resolved: =COUNTIF(AND(ISDATE([INQUIRY DATE SUBMISSION]1, "Cell contains a date", [DATE RESOLVED]1, "Cell doesn't contain a date")). What am I doing wrong? Please help! Thank you so much!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!