show date entered in another column if a box is checked

System · 12/21/22

This discussion was created from comments split from: Counting checkboxes in a column when using column formulas.

haley brianne · 12/21/22

Hi I am trying to write a formula to show the date that is entered in another column if a box is checked.

When Requested Delivery Date is a date and Confirmation from Omni is checked, then show the date in the Testing Column.

See screenshot attached.

Dale Murphy · 12/21/22

@haley brianne Is "the date" the Requested Delivery Date? Or is it the actual date the Confirmation box is checked?

If the first, then a formula in [Testing] column along the lines of:

=IF(Confirmation@row = true, IF([Requested Delivery]@row <> "", [Requested Delivery]@row, "No date"), "Not confirmed")

should work.

If the latter, use a workflow to "Record the date ..." when the box is checked and Requested Delivery is not blank.

dm

Answers