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.
Helloe Everyone! I’m trying to reference another sheet in Smartsheet, but I’ve noticed that sometimes it loads quickly, while other times it takes a very long time to display the list. Does anyone know why this happens? Is there a way to reduce how often this issue occurs? Today, I can’t get anything to load at all. 😑
Hello - Is there a work around in a Report to list multiple sheets in an order that I choose? Sorting doesn't give me the order in which I want them to appear in the report or in a widget on a dashboard. I would like them in a specific order. Thank you.
I need to revise/expand a filter - the list of items in the filter NOT the filter name - in a dashboard I created. Is this done through the dashboard or through the main data sheet?
