I would like to create a formula text field that will autopopulate when a specific condition such as a certain date is met, but will allow the user to input their own value if the condition is not met. I would also like to know if this is possible with checkbox fields.
If[Bid Due Date] > Date(2015,8,15), "Expired", [Bid Status Override])
I'm not sure what you mearn for a checkbox, but here is a guess.
If([my checkbox field]= true, "Expired", [Bid Status Override])
[My multiple choice field]="Completed", true,
[My supplementary checkbox field]=true, true)
The formula above will first check if the met,idle choice field is equal to Competed. If so, the suit is true (checked) and the formula stops there.
If false it goes on to the next test and if the override checkbox is checked, then again, true.
Else, it defaults to false.