GarryD’s Profile

Community member since March 2018

points
19
Area of expertise
Project Management
About Me
20+ year of: Facilities, Construction Project, Financial, Procurement Management. Believe SmartSheet is a strong solution on the edge of being a great solution with some additional fundamental improvements.

1

I have a standard project sheet.  I added one column called Today that in Row1 links to a separate sheet that will be triggered everyday so that it gets Today's date (this gets you around using the Today function which only triggers when a sheet is opened), every row below that first row then has a

7

Hey guys.

 

So, I'm curious if there's a way to do something. I want to detect certain changes in a cell, and modify another cell based on the date those changes occur.

 

The goal here is to automate the entry of dates of completion. I've thought about entering the following formula in a date cell: