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!
Answers
-
Try...
=COUNTIFS([Inquiry Submission Date]:[Inquiry Submission Date], ISDATE(@cell), [Date Resolved]:[Date Resolved], "")
-
Works perfectly! You're awesome!!
-
Happy to help! 👍️
Please don't forget to flag the most appropriate response as "helpful" so that others searching for a similar solution can know that one may be found here.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!