I have a date field and I need to set a value based on a calculate field.
the calculate field simply depends on a yes/no question. If the answer is yes, a previously recorded date value is set, else set empty string and let the user pick a date.
However, I noticed that when the answer is yes, the calculate field doesn’t set the date value. Here’s the link of the form: https://docs.google.com/spreadsheets/d/1tvwxrPjTatF8SKU0d4kCIRdSeM48ggyunWC9hO5ZCxw/edit?usp=sharing