Help with formula using YEAR function


I have a need to count rows where:

  • Issue Type = Story
  • Labels include LND-Product
  • Status = Done
  • Year of Resolution Date = 2020

COUNTIFS({JIRA Tickets Issue Type}, "Story", {JIRA Tickets Labels}, "LND-Product", {JIRA Tickets Status}, "Done", YEAR({JIRA Tickets Resolution}),= 2020))

Says the cell is Unparseable but I cannot see what is wrong.

Help appreciated...

Best Answer


  • Pamb10
    Pamb10 ✭✭✭✭

    Thank you very much. Learned something new today!

  • Guangda Shi
    Guangda Shi ✭✭✭

    I tried to do something similar but it's not working. Can you see why? I want to count how many time a particular Process was used in 2015. "Process Req" and "Enter Date" are in separate columns.

    =COUNTIFS({Process Req}, Category2), {Enter Date}, YEAR(@cell)=2015)

  • MCorbin
    MCorbin Overachievers Alumni

    You have a close parentheses after Category 2. Remove that and it should work

    =COUNTIFS({Process Req}, Category2, {Enter Date}, YEAR(@cell)=2015)

  • Guangda Shi
    Guangda Shi ✭✭✭

    Great! It worked!!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!