MAX Formula for Cells?

ejacksonBPT

How do I get the MAX date from a few cells?

For instance, how do I write a formula to pull the latest Finish date from Task 2 through Task 5 ?

Secondly how would I write it to pull the latest Finish date for Task 1, Task 2 and Task5 ?

Paul Newcome

You would use the MAX function. You can either specify a rage

Finish1:Finish5

or you can indicate specific cells

Finish1, Finish2, Finish5

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

.

ejacksonBPT

This isn't working. What am I doing wrong?

Isis Taylor

Can this function be used if the actual columns names are the dates? Or would the sheet have to be changed to have the weekly dates as values in a row?

Paul Newcome

@ejacksonBPT You cannot put formulas in columns being used by the dependency settings. If you are trying to get a roll-up of the tasks, insert a row above the tasks you want to summarize, and then indent the rows you want to summarize so that they are child rows. The dependency settings will automatically roll up the dates for you.

Paul Newcome

@Isis Taylor The dates need to be in cells and stored as date values (in date type column or columns). You cannot use a function to evaluate column names.

Isis Taylor

Thanks @Paul Newcome , that's what I thought. My coworker had her columns set up with the weekly dates and was trying to apply the Max formula.

Paul Newcome

Happy to help. 👍️

ejacksonBPT

Thanks @Paul Newcome