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?


Report
All responses (
Answers (