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?
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?
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.
Preeyanka