Count Date + N/A

Options
RobNY2
RobNY2 ✭✭
edited 11/15/22 in Formulas and Functions

I have a columns "LAN M Actual Complete" and another column "2nd Touch Indicator"

I need total Site complete: count if "LAN M Actual Complete" has a date and "N/A" in the "2nd Touch Indicator column"

Dont' count if "LAN M Actual Complete" has a date or no date and "2nd Touch Indicator" is blank or something else besides "N/A"

Only count if there is a date on "LAN M Actual Complete and N/A on "2nd Touch Indicator" columns







Thanks

Rob

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!