Calculated SP Field

[Sanchez]

I have a Calculated Column that helps me capture the current fiscal quarter when a form is submitted. Seems like Calculated fields aren’t visible in DFFS New Form. Is there a way to make a calculated field visible on a form? If not, is there a formula I can use on the ‘Set field value’ rule of a text field that could return the same value? or a Custom JS I can plug in?

Current formula I’m using in the standard Calculated field is:
=YEAR(Created)&”Q”&CHOOSE(MONTH(Created),1,1,1,2,2,2,3,3,3,4,4,4)

It returns as “2022Q2” format

Calculated field name: QtrCal
Text field name: YrQtr

[Alexander Bautz]

Calculated columns are only visible in DispForm in SharePoint – this is not specific for DFFS.

Even if the column is not visible, the value in the calculated column will be properly calculated when you save the form.

Alexander

[Author]

Posts