Calculated Field Auto-Refresh Giving 'N/A'

Question

Hello,

I have a calculated field on a request form that is giving me a value of N/A and I am not sure why.

How this field works it is pulls a number from another calculated field and uses 'ADDWEEKDAYS' to add that number to today's date.

When I am filling out the request form, my calculated field that populates a number (which auto-refreshes) while I am choosing different options in the request form. However my date field does not auto-refresh and instead gives me N/A as a result.

It is worth mentioning that after submitting the request, the date field populates fine. I am hoping to get a live refresh of that date field, on the request form, as users are filling the info in/before submission.

Is it because I am calculating this field off of another calculated field? Is what I am attempting possible?

Thank you,

Eric

skyehansen · Accepted Answer

Yes (it's because it's a calculation of a calculation).

You could submit a case to Support and see if that was the intention (if not, you could get this fixed).

If it's working as intended... is there a reason you've made a calculation of a calculation? Why not get copilot to just make the combined calculation in one field?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded