How to keep the cell value while returning a value to the other cell?

jho.l1T3

For the example in the photo:

If the Status is 'In Progress' the Actual Start Date will have the today's date or when you click the 'In Progress', then when you click the 'Pending' the Actual Start Date's value should remain to when the date you click it. May I know what condition I can use?

=IF(Status@row = "In Progress", "", IF(Status@row = "Pending", TODAY())

Kerry St. Thomas

You can't record / report Cell History data. To preserve data, add column/s and use those columns as the ones to surface in reporting and your existing columns to capture information like "Add A Date" automations or manual entries. So using your current arrangement, create a new Reporting Start Date column that is essentially like the formula here, if I get what you're trying to do.

=IF (Status@row = "Pending", [Pending Start]@row, IF (Status@row = "In Progress", TODAY(), [Start Date]@row)

dojones

You can do it with an Automation to get it to perform as you want. The issue is that if you change it to Pending and then back to In Progress, then the date will update again.

When Status is changed to In Progress, the Automation will enter today's date.

If you want to maintain the original start date, put in a helper column. Below it is called Original Start Date.

Then use 2 workflows. If Status is changed to In Progress and Original Start Date is blank, set Actual Start Date to date (which is today) and set Original Start Date to Started. This way, once Original Start Date is set to Started, the Actual Start Date will not change.

jho.l1T3

thankyou on this!