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

Options

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.

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!