
Announcements
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?
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,