How can I fix the range of my Average formula within a row?

Hi there!

Normally, I am using formulas to summary something like countifs, sum,average by column and it is very easyto have a fixed column range. Now, It's my first time to have a horizontally tabulated data and I want to get the average TAT within a row and make a fix range so that It will get the new columns being added.

I've tried to use the @row but it doen't work. Can anyone help me with the formula?

@Paul Newcome , I saw you helped a lot of people dealing with formulas. Maybe you can help.


Best Answers


  • David Joyeuse
    David Joyeuse ✭✭✭✭✭

    @Julius Benn Sabeniano

    Seems I mistaken on my formula.

    Should be:

    =SUMIF([Day 1]@row:[Day 31]@row, [Day 1]$1:[Day 31]$1, AND(@cell>=TODAY(), @cell<TODAY(4)))/4

    The formula on the previous post will count 5 days instead of 4.

    Sorry about that.

    Hope it helped!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!