How to count number of tasks and due dates of another sheet

Bernard MW
Bernard MW ✭✭
edited 09/27/21 in Formulas and Functions

Hi, I'm trying to make Metrics sheet which I would like to calculate the number of tasks of each person by name and also their past due tasks I did some formulas but they seem to be #INVALID

Below are the formulas I did for tasks :

=COUNTIFS({Name of other sheet Range 1}, FIND("Name", @cell) > 0)

Formula I did for past due tasks :

=COUNTIFS({Name of other sheet Range 1}, FIND("Name", @cell) > 0, {Name of other sheet Range 3}, "In Progress", {Name of other sheet Range 2}, "Yes")

Tags:
«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!