Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

If field isn't blank, check the box

Topic Labels: Formulas
824 2
Showing results for 
Search instead for 
Did you mean: 


I have a date field and a checkbox field. Can I write a formula that says if there is a date in the date field, check the box in the other field?

Eg “Date Commission Paid” has a date, so “Commission Paid” is ticked?

2 Replies 2

A formula field cannot change the value in a different field. It can only show the value that it computes. You could have the formula field show the check box itself.

IF({Date Commission Paid}, "✔️");

Great, thanks for your reply!