Variable help text via calculated field not working

Question

I'm trying to use a calculated field to display help text in case certain criteria from a field selection is met.

If the date selected in a launch date field is less than five business days away, then I want the calculated field to display a statement.

Here is the formula I am using:

IF({DE:Launch Date}<=(ADDWEEKDAYS($$TODAY,"5")),"Help Text")

The calculated field format is "Text" but the calculation is showing as "N/A" regardless of what date I pick in the Launch Date date picker.

Any recommendations on how I fix this calculated field?

skyehansen · Accepted Answer

If you see that your calculation is working when you regularly edit an existing form, but isn't working in the requests area, then I feel that it's more an issue with the requests area than your field. Have you considered submitting a case to Support? (or if you're not the authorized service contact, you could have your admin submit the case?)

skyehansen · Answer

the formula is working for me. Is it possible you may have forgotten to click on "Apply to existing calculations" or maybe you are changing the wrong date field?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded