Assistance Needed - Summing Values Based on Multi-Select Column

Options

Dear Team,

I hope this message finds you well. I am seeking your assistance in summing values on the TAT column based on the selections made in the Solution Area column. As you can observe from the attached image, the Solution Area is a multi-select column. My objective is to calculate the sum of values wherever my specified conditions are met.

However, the current formula I have been trying to use to achieve the desired result is not yielding the correct outcome. I kindly request your expertise in resolving this issue and finding the appropriate formula for the task.

Thank you for your prompt attention to this matter. Your support is greatly appreciated.

=SUM(SUMIFS({SRR: TAT}, {SRR: Type}, $Type@row, {SRR: Staffed Year}, $Year@row, {SRR: Staffed Month}, Jan$2, {SRR: Staffing Status}, "Fully Staffed", {SRR: Resource Location}, "US-Only", {SRR: Solution Area}, $Type$10, {SRR: Solution Area}, HAS(@cell, "B&CS (incl. Launch)")), SUMIFS({SRR: TAT}, {SRR: Type}, $Type@row, {SRR: Staffed Year}, $Year@row, {SRR: Staffed Month}, Jan$2, {SRR: Staffing Status}, "Fully Staffed", {SRR: Resource Location}, "US & EU", {SRR: Solution Area}, $Type$10,{SRR: Solution Area}, HAS(@cell, "B&CS (incl. Launch)")), SUMIFS({SRR: TAT}, {SRR: Type}, $Type@row, {SRR: Staffed Year}, $Year@row, {SRR: Staffed Month}, Jan$2, {SRR: Staffing Status}, "Fully Staffed", {SRR: Resource Location}, "GDC Team", {SRR: Solution Area}, $Type$10,{SRR: Solution Area}, HAS(@cell, "B&CS (incl. Launch)")))


Best Regards,

John

Answers

  • SteyJ
    SteyJ ✭✭✭✭✭✭
    Options

    If you need a quick solution, what you can do is create a report with this sheet data -->

    Provide the necessary filters for each Client and Project name (there doesn't seem to be any commonality in the cells you must sum)

    Once all the filters are applied, you can use the "Summary" tab in the report to sum a column which is in the report


    Sincerely,

    Jacob Stey

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!