#Invalid Data Type Formula Issue - Formulating % to plan

Hello,


I am trying to count performance to plan. I need to know if the required for ER is checked and the estimated complete date is DDMMYYY or earlier what the % should be.


=COUNTIFS([Required for ER Start]3:[Required for ER Start]929, 1, AND([Baseline Estimated End]3:[Baseline Estimated End]929, AND(ISDATE(@cell), @cell <= [Date for PTP]@row))) / COUNTIFS([Required for ER Start]3:[Required for ER Start]929, 1, AND([Baseline Estimated End]3:[Baseline Estimated End]929, ISDATE(@cell)))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!