Formulas

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…

Hello I'm using a detailed project WBS and unable to edit the start date on a row. This is a child row and does not have any predessessors. It states that this is a calculated value and cannot be changed, but when I double click on the cell, there is no formula noted. Tried deleting this row and adding a new row but have…

I would like the cell history to include the formula and the output of said formula instead of just the output. Having just the output makes it difficult to recreate broken formulas.

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…

I’m building a PM Team Workload Dashboard from our project tracker and want to account for the effort each project requires, beyond simply counting active projects. How have you set up workload weighting in Smartsheet? Do you base it on project phase, complexity, estimated hours, or a combination? I’d appreciate examples…

It would be incredibly helpful to support column formulas that can conditionally calculate values in some cells while allowing manual input in others, based on specified criteria. Essentially, I'm envisioning a hybrid column formula that can evaluate conditions at the row level and determine whether to calculate a value or…

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…

Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…