# What would be a equivalent smartsheet formula to this?

Options
✭✭✭

• ✭✭✭
Options

The formula would be: =Lookup(2,1/(mo number:mo number<>""),mo number:mo number)

• ✭✭✭✭✭✭
Options

You will probably find some help on here if you share a little more information. What are you trying to accomplish? What kind of data is in the mo number column?

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭
Options

I'm trying to recall the last entered value in a column of numbers that contains occasional blanks, to a reporting cell for a metric.

The formula works in excel but not in smartsheets.

• ✭✭✭✭✭✭
Options

You could use INDEX, COLLECT, and MAX to get the latest value that is a value from that column. You'll need to add an Auto Number system column with numeric values only - call it RowID. (You can hide this column once you add it, save, and refresh the browser window.) Then put this in your Current MO Number column:

=INDEX(COLLECT([MO Number]:[MO Number], RowID:RowID, (MAX(COLLECT RowID:RowID, [MO Number]:[MO Number], <>"")))), 1)

In English, this says "Find the value from MO Number column where the RowID value equals the highest RowID value where MO Number is not blank."

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭✭✭✭
Options

I hope you're well and safe!

Try this.

=MAX(COLLECT([MO Number]:[MO Number], Created:Created, <>"", [MO Number]:[MO Number], <>""))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!