In this video, you’ll learn how to automatically populate a date field with the data a specific status change was made.
In this scenario, we have a Sheet that organizes tasks. We have a Status column and a Start Date column. We want to make the Start Date column automatically populate to be the date that the Status of a task was marked In Progress.
In short, the process entails adding an Auto-Modifed (Date) column to your Sheet and using a copy row automation to copy the row when the Status changes to In Progress. Use a lookup formula utilizing the INDEX(MATCH()) functions to reference the modified field in the sheet with the copy to return that.
