In Dashpivot Web, you can automatically display different text depending on a number entered into a cell. For example, you might want to show “PASS” when a value is above a certain threshold and “FAIL” when it isn’t. This article shows how to write simple formulas to handle these scenarios so your forms or templates display dynamic, conditional text.
Video Walkthrough
Prerequisites
Before you begin make sure you have the following:
Plan: Standard
Permission: Access to edit and use formula fields in your template
Skills Required: Dashpivot Template Editing, Excel-style Formulas
Device Type: Computer (web browser)
Subscription: Dashpivot
Step-by-Step Instructions
Open your Dashpivot template and navigate to the table where the formula field is selected.
Use an IF formula to display text when a number is below a value.
For example, if the number in cell A1 is less than 50, then show “FAIL”, otherwise show “PASS”:
=IF(A1<50,"FAIL","PASS")
Use an IF formula to display text when a number is above a value.
For example, if the number in cell A1 is above 20, then show “PASS”, otherwise show “FAIL”
=IF(A1>20,"PASS","FAIL")
Use an IF formula with OR to check whether a number falls outside a range.
For example, if the number in cell A1 is less than –0.05 or greater than 0.05, show “FAIL”, otherwise show “PASS”:
=IF((OR(A1<(-0.05),A1>0.05)),"FAIL","PASS")