Formulas not working for resource allocation sheet

matt_k

Hi,

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))

Thanks,

Matt

ericncarr

If I'm understanding this correctly you'd just want to change your formula to = instead of contains as it's a contact column:

=COUNTIF({MK Sheet Name Range 2}, ="TEAMMEMBERNAME") - Ideally you'd have a contact column in the metrics sheet so you could do this instead:

=COUNTIF({MK Sheet Name Range 2}, =[Team Member]@row)