Last Populated Cell in Column

Paul McQuiston
edited 01/16/21 in Formulas and Functions

Hello everyone,

Hopefully an easy one!

I have a set of eight fixed rows on SS. I have built out colums representing the fiscal weeks . . (ie) 2021-01, 2021-02, 2021,03 ect. Each week I add a number, or text, in the revelent column.

I'm trying to find a formula to reference the last figure to the right. I'll then pull that to a dashboard.

Thanks!

Paul

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    edited 01/16/21

    Hi @Paul McQuiston ,

    There is probably an easier way but this should work:

    =IF(ISBLANK([2021-02]@row, [2021-01]@row, IF(ISBLANK([2021-03]@row, [2021-02]@row, IF(ISBLANK([2021-04]@row, [2021-03]@row, IF(ISBLANK([2021-05]@row, [2021-04]@row, IF(ISBLANK([2021-06]@row, [2021-05]@row, IF(ISBLANK([2021-07]@row, [2021-06]@row, IF(ISBLANK([2021-08]@row, [2021-07]@row, IF(ISBLANK([2021-09]@row, [2021-08]@row, IF(ISBLANK([2021-10]@row, [2021-09]@row, IF(ISBLANK([2021-11]@row, [2021-10]@row, IF(ISBLANK([2021-12]@row, [2021-11]@row, [2021-12]@row)))))))))))

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!