Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
I need help with nesting syntax please
I am trying to count the number of tasks assigned to a resource, let's say "Jane". The COUNTIF function works if there is only one resource in the "Assigned To" category, but I also need to include the number of times Jane appears in the "Assigned To" category if there are multiple resources assigned to a task. So I think I need to nest the CONTAINS function within the COUNTIF function. The following syntax returns Incorrect Argument Set.
=COUNTIFS(CONTAINS("Jane", [Assigned To]:[Assigned To]))
What should the correct syntax be?