show date entered in another column if a box is checked



  • haley brianne

    @Genevieve P.

    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
    Dale Murphy ✭✭✭✭✭✭

    @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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!