Formulas
Automation
Forms
Workflows
Table View
Formulas & Data
01
Tip
Use COLLECT() inside AVERAGE() to get conditional averages: since Smartsheet has no native AVERAGEIFS(). Example: =AVERAGE(COLLECT([Value]:[Value],[Status]:[Status],"Done")) returns average only for completed rows.
02
Tip
Intake forms cannot block negative number entries. Add a helper column using ABS() to silently convert all negative inputs to positive values downstream.
03
Tip
Create a dedicated Dropdown Source Sheet for all project-wide dropdowns. Reference it across all sheets so any update to a dropdown list only requires a single edit: one source, zero rework.
Forms & User Experience
04
Tip
Prevent accidental form submissions: Add a required numeric-only field as the final field. Users must consciously enter a number before submitting: acts as an intentional confirmation gate.
05
Tip
For long forms, group related fields logically, separate groups with visual dividers, and use conditional logic so the next group only reveals when the previous one is complete. Eliminates form fatigue.
Table View & Navigation
06
Tip
Table View auto-saves without CTRL+S and gives each user their own personalized filter and sort: without affecting anyone else's view.
07
Tip
In date fields, press T = Today | T+1 = Tomorrow | Y = Yesterday. Fast date entry without touching the calendar.
Automation & Workflows
08
Tip
Use {{Column Name}} in alert messages to dynamically insert live cell values. Example: "Task {{Task Name}} is now overdue" sends personalised, context-aware notifications.
09
Tip
In Auto-Number setup, use {{}} braces to pull current date, month, and year into auto-generated IDs. Makes record numbers informative and self-explanatory. Example: REQ-{{YYYY}}-{{MM}}-001
10
Tip
With many workflows running, tag each workflow name with a unique 10–15 digit code (e.g., first 6 digits = HHMMSS + 4 random letters + 5 digits). Embed the same code in email subjects or written data. Instantly trace which workflow triggered any action.