Automatically Check a Box upon entering a date

edited 12/09/19 in Using Smartsheet
10/31/19 Edited 12/09/19

In my Smartsheet sheet, I'd like to enter a date in a column and it would automatically check a box in another column. FYI - I have a surveyor in the field entering a date of his survey and I have a Manager who just needs to know the survey took place, but doesn't want the date.

Any advice is appreciated.

Thanks,

2019-10-31_Date-vs-Checkbox.JPG

Comments

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Put this in the checkbox column...

     

    =IF(ISDATE([Survey Date]@row), 1)

    thinkspi.com

  • Thanks Paul, it worked for that line, but when I tried to drag the formula to the entire column it doesn't work. Is there a way to tell it to work with the whole column, that way if I add a new row the formula stays in tack.

    Thanks again

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    What do you mean by "it doesn't work"? What exactly is it doing when you drag it? The formula itself is written to work on every single row on a row by row basis.

    thinkspi.com

  • My apologies Paul, I was doing it wrong. I selected the formula and then dragged down the blue box on the left to make it do the full column.

    Thanks again!

    2019-11-18_Formula-Checkbox.JPG

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Glad you got it figured out.

     

    Happy to help! yes

    thinkspi.com

Sign In or Register to comment.