AI Formula Generator

Smartsheet AI feature (generally available) that generates formulas from plain language descriptions. Understands your sheet's column names and types.

Syntax

smartsheet-mastery

Click sparkle icon in formula bar → Generate Formula → describe what you want

Example

smartsheet-mastery

// Description → Generated formula

// "Count rows where status is at risk and priority is high"
=COUNTIFS([Status]:[Status], "At Risk", [Priority]:[Priority], "High")

// "Show Overdue if due date is past and task is not complete"
=IF(AND([Due Date]@row < TODAY(), [% Complete]@row < 1), "Overdue", "OK")

// "Sum budget for Engineering department"
=SUMIFS([Budget]:[Budget], [Department]:[Department], "Engineering")

// "Calculate business days between start and end date"
=NETWORKDAYS([Start Date]@row, [End Date]@row)