Sharepoint List: Calculated Date Column

(0) Share

Report

Posted on by Olliedeecoswor

Hello,

I am building an equipment list for my facility. Some of our equipment requires calibration.

I have made a calculated column as follows:

=DATE(YEAR([Last Calibration]),MONTH([Last Calibration])+[Calibration Interval (Months)],DAY([Last Calibration]))

It works really well for items which require calibration and have a LAST CALIBRATION DATE. However, it still autofills for items which don't need calibration. See below:

Is there a way I can ensure that a value is only input into the Calibration Due column if the LAST CALIBRATION column has been filled in?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-jefferni on at

Like (0)

Report
Hi @Olliedeecoswor ,

Although this is a SharePoint question, I would like to provide you the solution.

=IF(ISBLANK([Last Calibration])," ",DATE(YEAR([Last Calibration]),MONTH([Last Calibration])+[Calibration Interval (Months)],DAY([Last Calibration]))

Best regards,

Was this reply helpful? Yes No