Skip to main content

Using Calculation Formulas in Smart Forms

Calculation Formulas help your teams fill out equipment/material cost totals, invoice markups and more, much quicker and more accurately

Yesenia Quintana avatar
Written by Yesenia Quintana
Updated this week

Overview

Calculation Formulas let you perform automatic calculations directly within your Smart Forms - perfect for tracking costs, materials, volumes, and more.

Each question type includes built-in formulas and options to display totals, add comments, and control visibility.


What Are Calculation Formulas?

Calculation Formulas are specialized fields that automatically compute totals based on what your crew fills out in your Smart Forms. They’re ideal for:

  • Cost estimation (equipment, materials, labor)

  • Measurement tracking (volume, distance)

  • Billing and invoicing


The Five Calculation Types

Type

Description

Formula

Common Use

Labor Cost Estimation

Calculates total labor cost per worker or subcontractor.

Hours Worked × Hourly Rate = Total Labor Cost

Timesheets, payroll roll-ups

Equipment & Material Cost Calculations

Estimates total cost of tools, materials, or rentals.

Quantity × Unit Cost = Total Cost

Procurement, job costing

Volume Calculations

Calculates volume for slabs, foundations, or excavations.

Length × Width × Depth = Volume

Concrete pours, material takeoffs

Distance Travelled (Mileage Logs)

Tracks vehicle or equipment mileage.

End Mileage − Start Mileage = Distance Travelled

Fleet management, reimbursements

Billing Calculations (Invoice Markup)

Generates total billing with markup.

(Labor + Materials + Equipment) × Markup % = Total Invoice

T&M jobs, client invoices


How to Add a Calculation Formula

  1. Open your Smart Forms template and drag and drop the Calculation Formulas question type into your form.

  2. Choose a Calculation Type from the dropdown.

  3. Customize field labels (e.g., “Worker”, “Hours”, “Rate”).

  4. (Optional) Enable:

    • Show Totals Row - displays total at the bottom

    • Add Comment Box - allows notes or clarifications

    • Required - ensures all fields are filled

  5. Save and preview your template to test the live calculations.


Tips for Best Use

  • Combine multiple calculation blocks for detailed reports (e.g., Labor + Materials + Mileage).

  • Use the “Visible” and “Read-only” options to control what users can edit or view.


Example

Scenario: A foreman logs labor hours and equipment rental in one Smart Form.

You can set this up in your form by doing the following:

  1. Add a Labor Cost Estimation question for staff hours.

  2. Add an Equipment & Material Cost question for rented tools.

  3. Add a Billing Calculation question to apply your markup automatically.

After the foreman fills out this form, it will be ready to be used for invoicing purposes, or exported.


FAQ

Can I edit the formula?

Not yet - each Calculation Formula comes with its preset formula, optimized for quick use and common calculation types.

Can I export totals?

Yes - totals appear in exports and reports alongside other form submission data.

Can I duplicate calculation questions?

Yes - just click Duplicate to reuse a question setup within the same or other templates.


Need Help?

If you need help setting up Calculation Formulas or want a walkthrough of Smart Forms:

  • 📩 Chat with our Support Team directly in the Workyard app

  • 💬 Or email us at help@workyard.com

Did this answer your question?