For records that require accurate readings — such as equipment maintenance logs, process monitoring sheets, environmental monitoring forms, calibration records, and quality control checklists — you can use a formula field in Dashpivot to automatically display a warning when a value is out of range.
For an overview of all available field types, see What fields are available in the Dashpivot template editor?
Setting up your table
Start by adding a table to your template. Your table should include a column for the reading (e.g. temperature) and a formula field column for the warning. For example, a calibration record table might look like this:
Date | Calibration Standard | Temperature Reading | Comments | Warning |
Date field | Text field | Number field (C+) | Text field | Formula field (fx) |
For example, a completed calibration record row might look like this:
Date | Calibration Standard | Temperature Reading | Comments | Warning |
01/07/2026 | Fluke 51-II | 30 | NA | Warning, with deviation. Recalibrate. |
Adding the formula
In the Warning column formula field, use the following IFS formula to check the temperature reading and display the appropriate message:
=IFS(C1="", "", C1>22, "Warning, with deviation. Recalibrate.", C1<20, "Too low temperature. Recalibrate.")
This formula checks the value in the temperature column and returns the relevant warning message if the reading is outside the acceptable range.
This formula works as follows:
If the cell is empty, the warning cell stays blank
If the reading is above 22°C, it displays "Warning, with deviation. Recalibrate."
If the reading is below 20°C, it displays "Too low temperature. Recalibrate.
When you fill out the form and add more logs, the formula populates automatically for each new row
Use Storm AI Templates to build your monitoring forms faster
Storm can generate a draft monitoring or quality control form based on a simple prompt. For example: "Create a calibration record form with date, calibration standard, temperature reading, and an automatic out-of-range warning field." You can then edit the generated template to add your formula logic.
Learn more
For more on building a complete quality management system, visit sitemate.com/systems/quality-management-system.
FAQs
Which field type should I use for the warning column?
Use a formula field (F+) in your table for the warning column. This allows Dashpivot to evaluate the reading and display the appropriate message automatically.
Can I set more than two warning thresholds?
Yes — the IFS formula supports multiple conditions. Add additional conditions to cover as many thresholds as needed.
Will the formula apply to every new row added to the table?
Yes — when a new log is added to the table, the formula populates automatically for that row.
What happens if no reading has been entered yet?
The warning cell may display the lower threshold message until a value is entered. This is expected and will resolve once a reading is added.