[HELP]Report Builder export formula

Lily36876 

Yes, it's possible to create blank columns and total formula columns in a report and have the total columns automatically calculated when users fill in data in Excel. However, this functionality would typically be implemented in Excel itself rather than in the report builder tool.

Here's how you can achieve this in Excel:

1. **Create Blank Columns**: In your Excel sheet, insert blank columns where you want users to input data. You can leave these columns empty initially.

2. **Create Total Formula Columns**: In adjacent columns, create formulas to calculate totals based on the data entered by users. You can use functions like SUM or SUMIF to calculate totals based on specific criteria.

3. **Data Input**: Users can then input data into the blank columns. As they do so, the total formula columns will automatically update to reflect the new totals.

4. **Protect Formulas**: To prevent users from accidentally modifying the formulas in the total columns, you can protect those cells containing the formulas. This can be done using Excel's cell protection features.

5. **Review and Validate**: Once users have inputted their data and the total columns have updated, you can review and validate the totals to ensure accuracy.

While this approach requires manual setup and input from users, it provides a flexible and familiar environment for users to input and calculate their data within Excel.

Alternatively, if you're looking for a more automated solution that integrates with your report builder tool, you may need to explore custom development or third-party add-ins that offer advanced Excel functionality. These solutions could potentially automate the process of creating blank columns and total formula columns based on your report data. However, they may require additional setup and customization.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!