What Formula should I use?

Good afternoon,

I am working on sheet where I want to display the most recent date data has been entered for a specific area. For example; I have column that shows which area is being reported on and a column for the week the information associated was filled in. I would like to capture in a "control column" when the last update was for each area so I can use the information to fill in another sheet.

The sheet is either filled in via a form, or resources input their new data on a new empty row.

Thanks in advance,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!