Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Sign in to ask your formula question or join a discussion.
Check out a list of all the available functions in Smartsheet.
Download the Formula Handbook with 100+ formulas and in-sheet examples.
An article with frequently used functions and additional resources.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
Hi Everyone, I’m looking for best practice recommendations for managing multiple Smartsheets that are connected across different projects and management reporting needs. Currently, I have several sheets linked together using formulas, which works, but I’m wondering if there is a more efficient or scalable approach. The…
Hi, We are using the same automations across countless sheets, and they have been working reliably for years. They are set up correctly, and no changes have been made to them. However, they stopped triggering yesterday. The automations are very simple and are triggered by cell changes. For example, if we enter "Done" in…
I am trying to average the "Days Shipped Delta" column from another sheet, based on (2) criteria from columns in that same sheet. (FY & Month) I am using the formula below but it returns #DIVIDE BY ZERO. =AVG(COLLECT({Days to Ship Delta}, {FY}, "FY26", {Month}, "01-January"))
Is anyone else having problems with column formulas this morning? My cells on the new rows aren't filling in, and the calculations aren't working correctly. The week number and allocation percentage, at a minimum, should have no problem filling in. But someone was able to override the column formula for the allocation…
Hello, I have automations enabled in several spreadsheets where, whenever any value is entered in a specific column, the entire row should be copied to another spreadsheet. The automation is configured so that the row is copied whenever the automation is triggered. However, I identified several cases that were properly…
I'm building executive reports to show which projects are active by quarter. I have start and end dates for each project to show the active date range. The output I'm looking for is a report showing what was active last quarter. Another report showing what is active this quarter. And what will be active next quarter.…
I am working with a marketing team to build a system using Smartsheet to track the status of campaigns. I have a main Campaign Management sheet that lists every campaign with a unique campaign code. A campaign may have 1 or more projects (typically asset based). I created a Project Management sheet that lists all projects,…
Hello! I'm sure this is a basic question that I'm just missing the how-to on. Our orginization has a master schedule for the year. I need to take from that master schedule and populate a different sheet based on a date. For example, master schedule has a column of dates. Multiple rows will contain that date. I need to pull…
I'm trying to show a summary of Projects, by both Branch and Status. I created the stacked bar chart below, but the Status series are in the wrong order and I can't find how to change them. The Status source column is a dropdown with the options in numerical order and the source sheet is sorted the same way, so I can't…