🏗️ Step 1: Add the Page to Your Cycle
Go to the Grant Editor tab→ Cycle Pages subtab.
Choose the specific Program and Cycle you are working on.
Scroll down to the page type dropdown menu and select Calculate Across Table Form.
Check the respective boxes if this page should appear in your Interim or Final Report.
Name the page (e.g., "Project Budget & Matching"), set the sequence, and click Add.
✍️ Step 2: Configure Table Logic
Click the blue ✏️ (pencil icon) next to your new page to define how the math will work.
Use the text editor at the top to provide clear instructions.
Select what is being gathered (Expense, Income, In-Kind, or Information). Choosing anything other than Information will display dollar signs on the PDF view.
Choose whether Column 1 and Column 2 should Add or Subtract to create the Column 3 total.
Name your table headings (up to 3).
Give the table a name (e.g., "Quarter 1 Expenses").
To require a specific item (like "Supplies"), enter the name and check Display.
To allow applicants to enter their own labels, check both Display and Freeform.
Click Add Line to add more rows (up to 30 per table).
You can add up to five sections per page. Begin filling out the secondary sections fields beneath your first one.
Click Update at the bottom of the page.
🎥 Click here for alt-text.
A screen recording of the GO Smart "Grant Editor" interface showing an administrator adding a "Calculate Across Table Form" titled "Project Budget & Matching." The administrator configures column headers, section titles, and line items (Supplies, Staff, Travel) before previewing the functional addition table.
⚠️ Alert: Sections on a single page must share the same Data Type and Operation Type. If you need one table to "Add" and another to "Subtract," you must create two separate Calculate Across Table pages.
💡 Tip: This tool is perfect for "Matching Grants" where you want to see the "Grant Request" in Column 1 and the "Applicant Match" in Column 2, with the "Total Project Cost" automatically appearing in Column 3.
📝 Note: If you select "Information" as the Data Type, the totals will still calculate.
🔗 Step 3 (Optional): Add to Interim and/or Final Reports
You can copy data from a main application page to a report page by selecting the "Pre-populate" option. To set up this auto-fill feature, follow these steps:
Go to the Page Type dropdown menu.
Select the Project Budget Page.
Locate the checkboxes for Interim Report Page and Final Report Page. Check the box for the report where you want the page to appear.
Find the Project Budget Page row (in the Interim Report or Final Report section) and look for the Edit and Delete icons. Directly underneath those icons, select the main application page from the 'Link to' dropdown and check the Pre-populate box.
🔎 Understanding the Calculation Features
Horizontal Math: Columns 1 and 2 allow for numeric entry. The final column automatically calculates based on your "Add" or "Subtract" setting.
Vertical Math: Every column automatically generates a total at the bottom of the table.