Sign in to join the conversation:
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:
https://help.smartsheet.com/function/vlookup
https://help.smartsheet.com/function/index
https://help.smartsheet.com/function/match
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.
Hi there! Our Account Manager today informed us that users would need to be paid members to receive and complete Update Requests going forward. I can't imagine that Form users would need to be members, but I don't know how that differs from Update Requests, since neither requires access to the underlying sheet. Is it…
This discussion was created from comments split from: Generate documents from row data.
Error occurs when opening Vault Apps in Smartsheet WorkApps. The app fails to load and displays an error message despite logging out and back in. Issue has been ongoing since last Monday
