I need to return the last entered value in a column that has blanks.


Currently have this formula and its not working with blanks in the column.

=INDEX([MO Estimated Hrs]:[MO Estimated Hrs], COUNTIFS([MO Estimated Hrs]:[MO Estimated Hrs], NOT(ISBLANK(@cell))))

The column will have blanks, I want to return the last entered value to the cell for reporting a metric.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!