Formula - Date if a condition is true
I am trying to use the formula - Date field to calculate a date that is nine months in the future from a specific date. This part is easy... I've used AdjustMonth([Date Due], 9). But I only want a ...
Forum Discussion
Works Great. Thank you. I'm trying to flowing the same logic for another field, but thinking I have too many variables...
I need a field to return one of two due dates if a specific field is not picked...
The three fields are:
Short or Long? - Multiple Choice
Due date- date field
Extension due date- Date field only if a box is checked.
If Short is chosen, then return "NA". If long is chosen, then I need it to return a date 30 days after either the due date or extension due date if box is checked.
Any Thoughts?
I need a field to return one of two due dates if a specific field is not picked...
The three fields are:
Short or Long? - Multiple Choice
Due date- date field
Extension due date- Date field only if a box is checked.
If Short is chosen, then return "NA". If long is chosen, then I need it to return a date 30 days after either the due date or extension due date if box is checked.
Any Thoughts?
