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.
I am wanting to send a request for an update to our inventory control people when we have non-conforming material that needs to be contained in the system and physically. I have a column for each with a drop down of Yes, No,N/A. I have my automation setup for triggered when containment required changes to any value,…
I'd like to be able to enter a unique value in a form and have it prepopulate a few other areas of the form. For example, I'd like to enter an employee ID number in the FORM, and once entered the First and Last Name sections of the FORM would automatically populate with the correct information.
Hello- There's been a few question/discussions on this topic, but they are a but they are older posts. I'm trying to record the email/name and date when travel requests are approved. I'm capturing the approved date with a Record Date Automation, so that it easy, but the approved by field is getting messy. I'm currently…
