Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
How can I display the bottom (last entered) value of a column in a different "cell"
Hi John,
Here's an example using an INDEX function.
+1 is because it seems like you have one row empty in the top.
Depending on what you want to get the bottom value of, you could also use a MAX function. =MAX(Value:Value)
Try something like this.
=INDEX(Value:Value; COUNT((Value:Value)) + 1)
The same version but with the below changes for your and others convenience.
=INDEX(Value:Value, COUNT((Value:Value)) + 1)
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I am in conditional formatting and cant seem to figure out how it should be set up. This is what I am looking for. I'd like a cell to turn red if it has been 365 days since the date that is listed in the cell. Any help is greatly appreciated!
The below formula should give me the total price of a project filtering it by the panel name and the area. I do not want to include a certain supplier. Also Level 1 is totalling the child rows, so I want to filter that out as it give an inaccurate overall total of the price allocated to the panel and area. I can't figure…
I've created a dashboard with multiple graphs using data from the same report. I have added the report to the dashboard as well and set up the filter for use in the dashboard. Is this filter transferable to the graphs as well, given i can filter the report in the dashboard?
