ServiceTitan spec-based estimate templates (SBET) can turn field measurements into repeatable material and labor calculations, but the first configuration can be difficult. Common problems come from unfamiliar formula rules and from assumptions that do not match field conditions. Because the system runs on automated math, a syntax, formatting, or input error can change the final estimate. Treat formula design as part of the broader ServiceTitan Pricebook optimization workflow, not as an isolated spreadsheet exercise.
Once you understand the technical rules, map your real-world coverages, and adapt them to your trade, SBET can make repeated pricebook calculations more consistent and easier to maintain.
The technical rules of the math
According to ServiceTitan's official guide on setting up spec-based estimate templates, an SBET maps form fields to your pricebook items using mathematical rules inside a column called QuantityFormulaByName.
The golden rule of SBET syntax: any field from your measurement form must be enclosed in square brackets within your formula. For example, if you have a form field titled LinearFeet and you need a bracket every 2 feet, your formula is [LinearFeet] / 2.
ServiceTitan supports standard arithmetic — addition, subtraction, multiplication, and division — plus ROUNDUP (to avoid ordering partial units) and conditional IF statements. Three syntax rules trip people up most:
- Unlike Excel, you do not start formulas with an equals sign.
- Referenced form fields must be configured as Number fields. If a tech types words into a text field, the formula collapses.
- Your Excel import headers must be entirely space-free (use ParentTag, not Parent Tag).
Why your calculations come out wrong
A recurring setup problem is a template whose final calculation does not match the field result. When that happens, check whether the formula's assumptions match real-world material coverages and the values collected by the form.
Learning the syntax is only half the battle — you also have to know the exact coverage of each line item. If your formula divides an area by a coverage rate, but the manufacturer changes the packaging or your crew uses a different waste margin, your estimate is immediately short on materials or over budget on labor. Audit your formulas so the math variables match your physical inventory reality.
It's not just for roofing
ServiceTitan markets spec-based templates heavily toward residential roofing, and because they include a built-in Roofing Formula Glossary, many non-roofing trades ignore the feature entirely. That is a big missed opportunity. As long as you build the right form fields and align them with the proper formulas, SBET works for other exterior and structural trades:
- Fencing: build formulas that take [TotalLinearFeet] and [GateCount] to calculate exactly how many posts, rails, pickets, and hardware kits are required.
- Trims and siding: input a perimeter measurement and use [Perimeter] * 1.10 to automatically factor in a 10% waste margin.
The bottom line
Don't let the custom algebra intimidate you, and don't assume the feature is only for roofers. Build familiarity with the backend formula rules, lock your field forms to strict numeric fields, and map your true material coverages. Then apply the same category, cost, and maintenance controls in the ServiceTitan Pricebook best-practices guide.