This feature allows you to display conditional disclaimer text within a table row based on a selected value. It is commonly used when you want a specific message to appear automatically depending on a List field selection in the same row. This applies to both Default and Prefilled tables in Dashpivot Web templates and is designed for template editors configuring conditional logic within forms.
Prerequisites
Before you begin make sure you have the following:
Plan: Standard (or higher)
Permission: Org Controller (Home Folder) or Org Controller, Project Controller, Team Controller (Team Folder)
Skills Required: Dashpivot, Basic excel formula skills
Device Type: computer
Subscription: Dashpivot Web
Step-by-Step Instructions
Open your template in Dashpivot Web and locate the table (Default or Prefilled) where you want the conditional disclaimer text.
In the table, identify the List field cell whose selection will determine the disclaimer.
Select a Display cell at the end of the same row where the disclaimer text should appear.
Enter the IF formula in the Display cell using this structure:
=IF(Test, Then value, Otherwise_Value)
Replace Test with your condition, Then value with the text to show when the condition is true, and Otherwise_Value with the text when the condition is false.
For example, to display “Leave has been approved” when the list cell equals “APPROVED” and “Leave is not approved” otherwise, enter:
=IF(C1="APPROVED", "Leave has been approved", "Leave is not approved")
(In this example, C1 is the List field and the formula is placed in D1.)
If you need more than two conditions, use IFS instead of IF. Example structure:
=IFS(Condition1, Value1, Condition2, Value2, Condition3, Value3, 1=1, "")
Save the template. When filling out the form, the disclaimer text will update automatically based on the dropdown selection.