How to Alter the "Sheet - IT Ticket Metrics"

I want to alter this sheet, found in the IT ticket Template, to just show the metrics for a specific customer.

the original formula looks like this:

=COUNTIF({Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1)

and my attempt to specify to a single customer looks like this

=COUNTIFS({Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1[{Customer}:{Customer},"Name"])

It's returning Unparsable. Any thoughts would be appreciated. I'll also need to do this for the other cells in the sheet.

If there's another way of doing this I'm open to ideas.

Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    @OliC

    Excellent!

    Happy to help!

    Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @OliC

    I hope you're well and safe!

    Try something like this.

    =
    COUNTIFS({Customer},"Name", 
    {Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1)
    

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Getting #INVALIDREF now... so that's progress...

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    @OliC

    Have you created the Cross-Sheet reference for the Customer Range?

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Thanks Andree

    Think I've sorted it!

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    @OliC

    Excellent!

    Happy to help!

    Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.