Date Completed triggers Check Box

SherryFox

I want my user to enter the Completed date and the Check box in the Completed column gets checked. I know this is simple, and I have found answers for the other way, but I want it set this way.

Paul Newcome

You could use a basic IF statement for this:

=IF([Completed On]@row <> "", 1)

Paul Newcome

You could use a basic IF statement for this:

=IF([Completed On]@row <> "", 1)

SherryFox

@Paul Newcome ,

I knew it was a simple answer! Thanks so very much!

NickStaffordPM

Paul's formula will definitely work for you, but just figured i'd chime in and show a different way incase anyone references this in the future. This is will check to see if due date is blank, if not, it will check the box

=IF(ISBLANK([Column20]@row) = true, 0, 1)