# Article Name 3 Ways to Monitor Spending in Smartsheet # Article Summary Discover three ways to monitor spending in Smartsheet so you can track costs and watch budgets across your projects with clarity # Original HTML URL on Toriihq.com https://www.toriihq.com/articles/how-to-monitor-spending-smartsheet # Details Tracking costs across multiple Smartsheet projects shouldn’t feel like guesswork. Budgets shift, vendors bill late, and scattered sheets make it hard to see where money goes. You need one view that ties spend to scope and schedule. This guide shows three practical ways to monitor spending in Smartsheet, from granular line items to portfolio rollups. You’ll learn how to surface actuals vs. Budget, flag variances early, and keep stakeholders aligned, without rebuilding your process. ## Use Smartsheet's UI Here, you’ll use Smartsheet’s UI to set up a simple budget tracker, roll it up across work, and keep alerts on overspend. ### Start with a budget-ready sheet You can begin from scratch or from Smartsheet’s Project Budget template. The template gives you a working layout with cost columns and formulas. - In Smartsheet, open the Solution Center, search for Project Budget, and create the sheet. Smartsheet’s docs: Solution Center and Templates. - Rename it, pick a workspace, and set your currency format. Smartsheet’s docs: Column types and number/currency formatting. ### Add the cost columns you need Keep it simple first. You can always expand later. - Add or confirm these columns: - Task or Item (Primary column) - Category (Dropdown, like Labor, Materials, Software) - Planned Cost (Currency) - Actual Cost (Currency) - Variance (Text/Number) - Percent Variance (Text/Number) - To add a column, select the plus sign to the right of your columns and choose the type. Smartsheet’s docs: Column types; Edit column properties. ### Enter formulas for variance and percent variance Use column formulas so every new row calculates automatically. Smartsheet’s docs: Create and edit formulas; Column formulas. - In the first row of the Variance column, add: - In the first row of Percent Variance, add: - Right-Click each formula cell and select Convert to column formula. ### Roll up totals with Sheet Summary Sheet Summary fields are the easiest way to get totals and KPIs without sticky footer rows. Smartsheet’s docs: Use Sheet Summary fields. - Open the Sheet Summary panel. - Add these fields and formulas: - Total Planned: - Total Actual: - Total Variance: - Variance Percent: ### Highlight overspend with conditional formatting Set quick visuals so problem lines pop. Smartsheet’s docs: Conditional formatting. - Open Conditional Formatting and add rules: - If Variance is greater than 0, color the row light red. - If Percent Variance is greater than 0.1, bold the row or color the text. - Keep rules simple so teammates understand what they mean. ### Group and summarize spending with a row report Reports let you group by Category or Vendor and see totals at a glance. Smartsheet’s docs: Create row reports; Group, sort, and summarize a report. - Create a new Row Report. - Add your budget sheet as a source. - Show columns you care about: Category, Planned Cost, Actual Cost, Variance. - Group by Category or Vendor. - In the Summaries pane, set Planned and Actual to Sum, and Variance to Sum. ### Watch KPIs on a dashboard Dashboards turn those totals into live, easy-to-scan widgets. Smartsheet’s docs: Build a dashboard; Add widgets to a dashboard; Chart widget; Metric widget. - Create a new Dashboard. - Add a Metric widget and point it at your Sheet Summary fields for Total Planned, Total Actual, and Total Variance. - Add a Chart widget and point it at your Report to compare Actual vs Planned by Category. - Keep labels clear and limit charts to what you’ll scan daily. ### Get alerted when spend crosses a limit Automations help you react fast without sifting through rows. Smartsheet’s docs: Create an automated workflow; Alert someone; Change-based triggers. - Open Automation and create a workflow. - Trigger: When rows are changed. - Condition: Variance greater than 0 or Percent Variance greater than your threshold. - Action: Alert someone. Choose recipients and customize the message. Include row fields like Task, Category, Planned, Actual, and Variance. ### Roll up spending across multiple projects with a Summary Report If teams track costs in separate sheets, pull their Sheet Summary fields into one portfolio view. Smartsheet’s docs: Create a Summary Report. - Create a Summary Report. - Choose the workspace or folder that holds your budget sheets. - Select the Sheet Summary fields to include: Total Planned, Total Actual, Total Variance. - Group by Project Name or Owner, and add Sum summaries. - Use this report as the data source for portfolio charts on a dashboard. ### Lock what matters and share the sheet Keep formulas and structure safe, and share widely so people update their parts. Smartsheet’s docs: Lock rows and columns; Share a sheet. - Lock columns with formulas like Variance and Percent Variance. - Share the sheet and report with the right permissions: - Editors can update Actual Cost. - Admins can edit structure and formulas. Tips that save time: - Use dropdowns for Category and Vendor so reports group cleanly. - Keep one source of truth for Actual Cost. If it lives in another sheet, use cross-sheet formulas with clear cell references. Smartsheet’s docs: Formulas using cross-sheet references. - Reuse your dashboard by pointing it at different reports or summary fields per project. ## Use Torii Instead of working directly in Smartsheet, you can rely on Torii [https://www.toriihq.com/], a SaaS Management Platform, to track Smartsheet spend. SMPs give teams a centralized place to manage SaaS subscriptions and integrations, making it easy to programmatically onboard/offboard users, review subscription details, and more. Unlike the manual steps you might take in Smartsheet, Torii lets you automate the workflow so actions run as soon as a specified trigger occurs. Triggers can include a new hire, a departing employee, a contract renewal, and similar events. If this task repeats often, automation can save considerable time. To keep an eye on Smartsheet spending directly from Torii, follow these steps: ### 1. Sign up for Torii Contact Torii [https://www.toriihq.com/], and request your free two-week proof-of-concept. ### 2. Connect your Smartsheet account to Torii After your account is active, connect Smartsheet to Torii (assuming you already have an account). Here are the instructions for the Smartsheet integration [https://support.toriihq.com/hc/en-us/articles/5198770970139]. ### 3. Create a Torii workflow for Smartsheet In Torii, you can build automated workflows to monitor Smartsheet spend. Go to the Workflows tab, configure a trigger, and then add an action that tracks spending in Smartsheet. From then on, whenever the trigger fires, the monitoring will run automatically. ## Use Smartsheet's API Here, you’ll use the Smartsheet API to pull spend data from a sheet, calculate totals, and keep a running summary up to date. No UI clicks. Just API calls. ### Get ready: authenticate and find your budget sheet You’ll need a Smartsheet access token with access to the sheet that stores spend. - Set an environment variable for your token: export SMARTSHEETTOKEN=yourtokenhere - List sheets and find the one that holds your spend data: Example curl is: - If you prefer search by name: Example curl is: Note the sheetId you’ll use next. ### Map column names to column IDs You’ll compute totals by reading cells. Cells reference columns by ID, so map your spend columns (for example Amount, Category, Vendor, Date) to IDs first. Example curl is: Quick Node.js snippet to build a column map by name: ### Pull rows and calculate spend totals Grab all rows, then sum the Amount column. If your Amount column is Currency, use cell.value. It’s numeric even if display shows a currency symbol. - Fetch all rows: Example curl is: - Calculate totals in code: Tip: - If your sheet is large, use pagination: Example curl is: ### Store or read totals with Sheet Summary fields If you already keep totals in Sheet Summary, read them. If not, create fields like Total Spend and update them on each run. - Read summary: Example curl is: - Create summary fields (for example Total Spend and MTD Spend): Example curl is: - Update summary fields after you compute totals. You’ll need the field IDs from the read summary response: Example curl is: Notes: - Summary field type for numbers is TEXTNUMBER. Currency formatting is a display choice; the stored value is numeric. - You can also use formulas in summary fields, for example =SUM([Amount]:[Amount]), if you prefer Smartsheet to calculate totals. ### Keep it live with a webhook Use webhooks so your totals refresh when rows change. - Create a webhook scoped to your sheet: Example curl is: - Verify the webhook challenge: - Smartsheet sends a POST to your callback with a Smartsheet-Hook-Challenge header. - Respond with HTTP 200 and the same value in a Smartsheet-Hook-Response header. - Store the Smartsheet-Hook-Secret header value from that request. You’ll use it to validate future notifications. Example Node.js express-style handler: ### Recalculate on webhook events and update summary When you receive an event, you can fetch only the changed rows or just recompute everything. For smaller sheets, full recompute is simple and safe. - Option A. Fetch only changed rows: - Parse the event payload for row IDs, then: Example curl is: - Option B. Recompute totals from the whole sheet: Example curl is: - Update your summary fields with the new totals (same PUT call as above). ### Add practical filters for better monitoring You can calculate different views with the same sheet data, then write each to its own summary field: - Common filters: - Current month spend - By vendor - By category - Pending vs approved spend (if you track status) Example: filter month-to-date by checking a Date column in code before adding to the total. ### Quick end-to-end script outline This simple flow runs anywhere you can host code: - [ ] Fetch sheet and build column map. - [ ] Compute totals you care about. - [ ] Create summary fields if missing; then update values. - [ ] Create webhook and verify it. - [ ] On events, validate HMAC, recompute, update summary. That’s it. You’re monitoring spend through the Smartsheet API, keeping totals accurate without touching the UI.