Formulas not working for resource allocation sheet
I have reached out to Smartsheet support, but haven't received a response in almost a month so thought I would try here. With our plan, we don't have resource allocation/workload view so I am trying to create a sheet for the team that shows allocation such as number of tasks, story points etc. However, the formulas I am using are returning 0 even though I think/hope they are correct. I am basically trying to pull the number of tasks assigned to each person from another sheet.
=COUNTIF(MK Sheet Name Range 2}, CONTAINS("TEAMMEMBERNAME", @cell))
Help Article Resources
Check out the Formula Handbook template!