Hello,
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?
If field isn't blank, check the box
+29A 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}, "✔️");
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.