Using Formulas on Dashpivot Web
By Adriana and 2 others3 authors58 articles
- How to Cross-Reference Tables in Formulas on Dashpivot Web
- Dashpivot Formulas Overview
- How to Auto-Number Rows in a Default Table on Dashpivot
- How to calculate date/time differences in a row on Dashpivot Web
- How to auto-populate dates when adding rows on Dashpivot Web
- How to Set Logic to Show Texts from List Drop-Down Selections on Dashpivot Web
- How to Populate Text or Numbers with Yes/No Selections in a Row on Dashpivot Web
- How to Populate Texts/Numbers from List Drop-Down Selections in a Row Table on Dashpivot Web
- How to Count Table Rows in a Default Table on Dashpivot Web
- How to Sum a Column at the Bottom of a Prefilled Table on Dashpivot Web
- How to Average a Column at the Bottom of a Prefilled Table on Dashpivot Web
- How to Duplicate Information from One Cell to Another Within One Table on Dashpivot Web
- How to Total Yes/No Selections at the Bottom of a Prefilled Table on Dashpivot Web
- How to Total Yes/No Selections from a Default Table to Another Table on Dashpivot Web
- How to Sum a Column from a Default Table Using Another Table (Cross-Referencing) on Dashpivot Web
- How to Average a Column from a Default Table Using Another Table Cross-Referencing on Dashpivot Web
- How to Generate a Score from a Table on Dashpivot Web
- How to use IF statements to display disclaimer text on Dashpivot Web
- How to generate a Pass/Fail result at the bottom of a table based on a count on Dashpivot Web
- How to generate an overall Pass/Fail based on score in a table on Dashpivot Web
- How to create a summary table at the bottom of a form on Dashpivot Web
- How to Add Up the Number of Rows of a Default Table on Dashpivot Web
- How to Calculate a Percentage Complete in a Dashpivot Table
- How to Format Date Fields in a Summary Table on Dashpivot Web
- How to total all instances of List dropdown items in a form on Dashpivot Web
- How to Total All Instances of Yes/No Items in a Form on Dashpivot Web
- How to Copy a Column from One Table to Another on Dashpivot Web
- How to Copy a Row from One Table to Another on Dashpivot Web
- Use Case Examples - Training: How to generate a % score from pass/fails from employee training
- Use Case Examples - Quality/Safety: How to generate a % score from pass/fails from inspections
- How to Calculate the Percentage of Rows Meeting Multiple Criteria in a Table (Dashpivot Web)
- Use Case Examples - Timesheets: how to total labour hours at the bottom of a table (incl. overtime, regular, total)
- How to Calculate a % Score Based on List Dropdown Selections in a Row on Dashpivot Web
- Use Case Scenarios - Timesheets (weekly timesheet): How to create a summary of labour hours from multiple tables (eg. broken down by total, normal, overtime)
- Use Case Scenarios - Timesheets (single employee with multiple projects): How to create a summary of labour hours from multiple tables (eg. broken down by total, normal, overtime)
- Use Case Scenarios - Timesheets (multiple teams): How to create a summary of labour hours from multiple tables (eg. broken down by total, normal, overtime)
- How to use formulas in Dashpivot templates
- Full list of supported formulas in Dashpivot
- Current formula limitations in Dashpivot
- Helpful time formulas in Dashpivot (with examples)
- Financial Formulas in Dashpivot (with examples)
- Information formulas in Dashpivot (data validation and error checking)
- Logical formulas in Dashpivot (with syntax and examples)
- Text formulas in Dashpivot (with syntax and examples)
- Lookup formulas in Dashpivot (with syntax and examples)
- Statistical formulas in Dashpivot (with syntax and examples)
- Operator formulas in Dashpivot (arithmetic and comparison functions)
- Math and trigonometry formulas in Dashpivot (with syntax and examples)
- How to do a Date and Time calculation on Dashpivot Web
- How to Populate a Number Based on a Dropdown Selection on Dashpivot
- How to Populate Text Based on Number Entered on Dashpivot Web
- How to Combine Cells Together on Dashpivot Web
- How to Calculate a Daily Cost on Dashpivot Web
- Can I add colors to words populated by a formula in Dashpivot Web?
- How to Configure INDEX and MATCH Formulas on Dashpivot
- How to Calculate Ordinary Hours in a Single Entry Timesheet on Dashpivot Web
- How to Calculate Time & Half Hours in a Single Entry Timesheet on Dashpivot Web
- How to Calculate Double Time Hours in a Single Entry Timesheet on Dashpivot Web