ServiceTitan spec-based estimate templates (SBET) promise to turn a quick field measurement form into accurate, instant material and labor estimates — but most contractors hit a brick wall the first time they try to set one up. The software isn't the problem; unfamiliarity with the formula rules is. Because the whole system runs on automated math, a single syntax slip or formatting error makes your final estimates come out wildly wrong.
The good news: once you understand a few basic technical rules, map your real-world coverages, and adapt them to your trade, SBET becomes one of the fastest tools in your pricebook.
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
The most common complaint is, "I set up the template, but the final calculation is completely wrong." When an SBET fails, it is almost always a disconnect between the software's math and real-world material coverages.
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 — and you can turn a complex, multi-variable estimate into a two-minute form-filling exercise for your team.