Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2014
    Posts
    4

    Unanswered: Return today's date when Yes in a column

    Hello,

    I am trying to have today's date returned when "yes" is selected in a column.

    I have a drop down in the column [enablement] asking "yes"/"No".
    I would like to have the next column [Date Modified] returning today's date when "yes" is selected in the [Enablement]column.

    Anyone could help, please?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Code:
    =If([enablement]="Yes", Now(), "")

    If you don't want time, just day, use Today() instead of Now()
    George
    Home | Blog

  3. #3
    Join Date
    Apr 2014
    Posts
    4
    Thank you very much George.

    This worked very well.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •