show date entered in another column if a box is checked
Options
System
Employee Admin
This discussion was created from comments split from: Counting checkboxes in a column when using column formulas.
Answers
-
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.
-
@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
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!