Calculated Field Auto-Refresh Giving 'N/A'

[Eric_D_Miller]

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 solution]

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?

[Eric_D_Miller]

Combining the two expressions was the ticket. Sometimes the simplest solution escapes me.

Thanks!