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 All, I feel like I am missing something simple. I am creating a new project via a Portfolio template. They are working great except for the pre-built data integration in the template is not in the new project. Its easy to re-add them but not a good experience for users. Any ideas on what I am forgetting. With the…
Hi Smartsheet Community, I'm working on an action management system where users create sub-actions through a Smartsheet Form. The requirement is simple: a sub-action's due date must be earlier than or equal to its parent action's due date. For example, if the parent action is due on June 30, 2027, users should not be able…
Hi, I have a Gantt covering 500+ rows of events past and planned. I use it to predict and track values around these events. Using helper columns to identify the current week, I get an email report on a Monday that tells me the upcoming events in the current week (7 days) and their values. Currently if an event spans…
Hi, I want to divide a total by different rows with different weights. I've accomplished this somewhat with the formula below. However, I need each row to total the top number for "WEEK 1 REG". Project 3 should return a zero since the box for that week is unchecked, so I want the 120 split by the other two rows. My weights…
I have two sheets, sheet on e (orders) captures orders in a field called "Item" . The column has a drop down and allows for multiple selections. Sheet 2 (stock) tracks stock levels. The sheet (stock) has a rows for items that correlates with the drop down options in I want to create a formula that counts the number of…
Since the retirement of Card view, and the forced use of Board View, as many users have already posted "that board is basically unusable due to performance lag and missing features". Has Smartsheet provided a timeline for all the current issues to be resolved? as the productively within our organization is already being…
Hi, I'd like to retrieve the total values excluding duplicates, this is the formula used: =COUNT(DISTINCT([Part Number]:[Part Number])) ; using the count formula only returns the total value of 3535, which is correct considering duplicated cells, I thought it was due to an error in the data format or something similar, so…
I'm building a Smartsheet workflow to generate Payment Contracts using three primary sheets and a staging sheet. Here's how the workflow operates: Sheet 1 → Sheet 2: Rows are automatically copied daily at 5:00 AM CT. Users can also check an Expedite box to trigger an immediate copy. Sheet 2 → Staging Sheet: The staging…
I am working in a sheet (Table View) editing a formula. Once I apply the formula (to the column), and then close out of the formula sidebar, I always get the following error, over and over even when I click OK. I have to reload the page. The edits to the formula are still there, thankfully. Anyone else get this error, and…