Why does my range change?

04/20/21 Edited 04/20/21
Answered - Pending Review

Every time I complete a formula the word TEMPLATE appears in my range, but does not appear in my sum_range.

Is that normal?

=SUMIF({Template of Sidewalk Database Module Range 1}, "Completed", {Sidewalk Database Module Range 1})


  • Bassam KhalilBassam Khalil ✭✭✭✭✭

    Hi @Valerie Luna - HPW

    Hope you are fine, please read the following article to understand the SUMIF function. and i advise you to use always the SUMIFS function because it works better.

    Best Regards

    Bassam.M Khalil

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as the accepted answer. It will make it easier for other Smartsheet Community members to find this solution or help to answer their questions.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Are you making sure that you are referencing the same sheet for both of the ranges?

    If so, it is just pulling the previously established name for that range meaning the sheet you are referencing had "Template of" in the name when that particular cross sheet reference was created. You can click inside of the reference and "Edit reference" to change the name if you like, but it really shouldn't affect anything as long as it is in fact referencing the correct sheet.

Sign In or Register to comment.