Welcome!

lookup function

Hi Iam looking to replicate the below lookup function in excel to get the last number filled out in a column range

=LOOKUP(2;1/(M11:M23<>"");M11:M23)

However this does not work in smartsheet

Hi Daryl,

You'd use a VLOOKUP function or an INDEX/MATCH combination instead.

More info:

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Depending on how the setup of the sheet(s), even an INDEX/COUNT(IFS) could work if you're looking down a single column.

Auto-populate an email into a form to reduce error
Is it possible to auto-populate an email domain in a field where people are asked to enter their email address? For example, I would like users to only have to type their name, without needing to enter anything after the “@” symbol, to reduce the chance of personal email addresses being entered.
Suddenly View Only on all Workspaces and Sheets I own
This discussion was created from comments split from: I am an editor on a smartsheet but can't edit the sheet.
Sharing with Editors outside our company
Good afternoon! My company works closely with another ambulance service, Company B. Both companies have a Smartsheet Enterprise plan. I have created a workspace that I need members of Company B to edit. Do I need to make them members on my account if they are already members on their account? Or do I just need to add their…