Variable help text via calculated field not working

[MikeMcGovernC1]

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]

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?

[MikeMcGovernC1]

I tried checking that box and ensured I am referencing the correct date field, but it is still not working.

I have this on an issue form so I am expecting/hoping for the text to appear when user is filling out the request to let them know something since they are requesting a launch date within 5 business days.

Just to confirm - you were able to see this work on an issue form in the Requests area?

[Sven-iX]

Hi @MikeMcGovernC1 

This doesn't work for me in the Request area - but it DOES work when you edit an issue... 

[skyehansen · Accepted solution]

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?) 

[MikeMcGovernC1]

I just submitted the support ticket - will report back!

[MikeMcGovernC1]

It was a caching issue with my browser lol - it worked perfectly after I cleared my cache *facepalm*