Reply To: index mystery

Inner Circle › Ask Smartsheet Guru Crew Anything › index mystery › Reply To: index mystery

October 10, 2025 at 8:14 pm #673
Darren
Keymaster

    Thanks for the screenshots, they are really helpful and let me know you have your cross sheet range correct.

    My initial thought is that the year in one sheet could be interpreted as text and another as a number.

    i can’t tell for sure unless you shared the sheets with me to guru@smartsheetguru.com

    You could try the following:
    =IF(ISBLANK([Year of Sale]@row), “”, COUNTIFS({Transaction Sheet | Transaction Year}, value(@cell) = value([Year of Sale]@row)))

    That will for number to number matching.

    Let me know if that works, if it doesn’t put the sheets in a workspace and share the workspace with me as a viewer, then I can copy it into my account and take a look.