Hi Community, report not update

I got the formula below, but not updating and keep going back 0

=COUNTIFS({Operations Report Range 1}, AND(IFERROR(MID(@cell, (FIND(":", @cell) - 2), 2), "") >= 13, IFERROR(MID(@cell, (FIND(":", @cell) - 2), 2), "") <= 16), {Operations Report Range 3}, AND(WEEKNUMBER(@cell) = WEEKNUMBER(Date@row), WEEKDAY(@cell) = 2))

I opened the sheet and saved, my report showed 1 or more, but the report showed 0 again after about 20 mins later.


  • Julio S.
    Julio S. Moderator
    edited 11/03/22

    Hi @Kin

    The Activity Log and Cell History in the sheet might be able to give you more context about the specific changes within the sheet that led to the values returned by the formula being updated.

    If you find that the changes made in the sheet when the values last changed to 0 don't make sense or look unexpected, I would recommend opening a ticket with our Support team via this form. Please make sure to include captures of the Activity Log and Cell History that can provide more context to the reported behavior.

    I hope that this can be of help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!