Checkbox populated another column with date

NLegresley

Hello

 

I have a checkbox column that I want when checked to copy the shipped date form one column (Shipped Date) to another column (Customer requested date). 

 

Is this possible with a formula?

Mike Wilday

Yes, you can enter the following formula into you customer requested date box. However, if someone hard codes a date over the formula, it will overwrite it and the formula will no longer exist. 

=IF([Checkbox Column Name]@row = 1, [Shipped Date]@row, "")

Andrée Starå

Hi,

To add to Mike's excellent advice.

If you want to store the date that the checkbox was checked without adding the date manually, you can use the third-party service, Zapier, for that use case.

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD