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.

Are text fields and checkboxes not showing in your Dynamic View Detailed Views pane today?
Hi everyone, in several of my Details Views for multiple Dynamic Views, text fields and/or checkboxes that are configured in the Dynamic View settings are not appearing in the Detailed View. Is anyone else seeing this today? I've not updated any of my configurations lately and don't know how to explain this! Thanks!
Timeline Widget's toggle of Set the default hierarchy state keeps resetting to off
The timeline widget has a toggle: Set the default hierarchy state. I am turning on "expand lanes by default." It seems regardless if I turn this "on", save, sign out, and sign back in, it automatically changes back to "off" when I log out. I have tried clearing my browser cache.
Graph Question
Can someone tell me how to get rid of the 120.0% max on this graph? It is always going total 100% and never any more, so I would like to use more of the space for graph display purposes. I even tried reducing it so that the largest value was 99.999%, thinking maybe being exactly 100 would cause the next "level" to…