When 'complete', date to be auto-filled

cltesh99671

Hello! 

I'm trying to setup a project plan for when a task is marked 'complete' it auto-fills the 'Finish Date' column. Would I use an If, then formula? If so, what would that formula look like?

Thanks!

Crystal 

Mike Wilday

Hi Crystal, this functionality is not currently available without using a third party tool like Zapier. We reverse-engineered our process to have the person enter a date and then have the status update accordingly. 

cltesh99671

Thanks, Mike! This is helpful. I'll try that approach.

Mike Wilday

Sounds good. Let me know if you have any questions! We created an Actual Start and an Actual finish date field to measure if the task was in progress or complete and changed the dropdown field with an IF function based on the dates being populated.