CountIF Formula #incorrect Argument Set

edited 03/19/22 in Formulas and Functions

I have project plan with activities, end date, status etc, I want to count if the Task Name column includes Workshop B and if the date is equal to or later than today.

The Formula I have is

=COUNTIF([Task Name]:[Task Name], " Workshop B", [End Date]:[End Date] > TODAY())

Pls any help or advise would be appreciated

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!