Formula for checkboxes

Suppuse I have a column called “Urgent” with a boolean type (checkbox)

I want it to be true for example when =DueDate-Today() < 2. I placed this formula in the default value field but it doesn’t work this way! What should I do then?

Perhaps DueDate < Today()-2 could work better?

1 Like

That will return a date

Hi Dmitriy,

You want to set the formula in the cell itself. Click into a cell and press “=”. That should pop up the formula builder. This makes the entire column formulaic.

The default value field in the column will only set the value of the cell for new rows. Default values can be also overwritten by users.