COUNTIF across multiple sheets

Options

How do I use the following formula to pull information from the "place holder" field from multiple sheets?


=COUNTIF([Assigned To]:[Assigned To], "place holder")

Answers

  • SteyJ
    SteyJ ✭✭✭✭✭✭
    edited 08/12/23
    Options

    Hello @nick.wilson,

    Highlight "place holder" and then select "Reference Another Sheet"

    From here you can select which cell value you would like to have as the placeholder in the other sheet.

    =COUNTIFS([Assigned To]:[Assigned To], "place holder")

    If you need to reference multiple sheets, you can do this formula multiple times, or you can do "=COUNTIFS" like this

    =COUNTIFS([Assigned To]:[Assigned To], "place holder", [Assigned To]:[Assigned To], "place holder 2")

    Hope this helps!

    Sincerely,

    Jacob Stey

  • nick.wilson
    Options

    That worked but I have one more question. How would I create a formula that will give you the sum of a list of numbers in column based on the Assigned To column? I tried the one below but it does not give you the sum per Assigned To contacts, just the sum per the column.


    =SUM([Assigned To]:[Time per task], "placeholder contact")

  • SteyJ
    SteyJ ✭✭✭✭✭✭
    edited 08/12/23
    Options

    Do you want to count how many tasks are assigned to a specific contact? I am wondering why you are using Time Per Task in your range when you can just do =SUMIF([Assigned To]:[Assigned To], "Placeholder contact")

    Hope this helps

    Sincerely,

    Jacob Stey

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!