Date Range formula for last date

I hope someone can help.

I am trying to create a formula in Smartsheet that can pull the last date (i.e. the latest date) from a range of cells. E.G.: I have x number of dates in a range of cells in column E and I want to create a formula to look at the range and show the last date in that range. I must admit I am not a formula guru by any stretch of the imagination.

Any help would be greatly appreciated.

Find more posts tagged with

Comments

Shaine Greenwood

Hi Penelope,

I'd recommend checking out our article on creating and editing formulas, mainly so that you can become familiar with referencing cells in Smartsheet: https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet

If you're trying to find the latest date (closest to today), then use a MAX function. For example:

=MAX([Column E]:[Column E])

More on MAX in our help center: https://help.smartsheet.com/function/max

If you need to find the oldest date (furthest from today), then use MIN:

https://help.smartsheet.com/function/min

Penelope Pitstop

Shaine, PERFECT!! Thank you very much and thank you for sharing the info on formulas. Very much appreciated.

Katya

How to input that =max[ ] function for specific rows under a column? For example, display the max date for column Actual Date in rows 19:27. This would be input in a parent row. The sheet has a different set of dates (Start Date) with dependencies applied.

Sign in to join the conversation!

Quick Links

Trending discussions

Project Dashboard
Is there an easy way to identify which cell or group of cells is being used for the information relaying from a sheet onto the dashboard?
Is it possible to create a Template and share it to other users?
Hi, I have the following dilemma- I have created a really good PMO system within smartsheets using different sheets & dashboards, I would love to roll this out to other users within my organisation to utilise it as a template My question is, is this possible and if so how do I do it? For context I am a consultant and we…
Smartsheet performance issues - current state
Hey there community. I'm conducting a bit of a straw poll of users to try and get to the bottom of whether the Smartsheet performance issues I'm seeing are down to me and my internet connection, or down to something Smartsheet's end. I've seen a significant increase in loading and refresh times over the past 3 months or…