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
A formula date field can only calculate to result in a date, and not text like "N/A".
But you can make a formula text field like this
IF([Exempt]= true, "N/A", ToText(AdjustMonth([Date Due], 9)))
If you are not happy with the way the date appears in text format, post back with an example of the format you want and I can help you.
But you can make a formula text field like this
IF([Exempt]= true, "N/A", ToText(AdjustMonth([Date Due], 9)))
If you are not happy with the way the date appears in text format, post back with an example of the format you want and I can help you.