web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Sharepoint List: Calcu...

Power Apps

Answered

Sharepoint List: Calculated Date Column

(0) Share

Report

Report

Posted on by Olliedeecoswor

4

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 Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Join the conversation