Formulas
Discussion List
- Hi all, At my job, we have been using SmartSheet for a while to manage our service projects. I am now starting to use Zapier to automatically create a new line for a project in SmartSheet once an uppo…
- Hi, This one is pretty easy in Excel but I have no idea how to do that in SmartSheet. I have 3 columns in SS: Fruit, Brand and Price [Fruit]1 is Apple , [Brand]1 is ABC Ltd. [Price]1 is 100 [Fruit]2 i…
- Does anyone have a formula that will calculate the following: Reaming = 194 Deadline = Sept 29 X = How many do i need to complete per day in order to make the deadline. Note: X should change based on …
- Hello Community Team, I'm working on automating a % Effort column for my project plan. I need to avg the % effort at the parent level of its associated children. I want to do this automatically withou…
- I amy trying to execute the following function. Does anyone know if it, or something like it, is possible: = AVG(COLLECT(CHILDREN(), CHILDREN(), ISNUMBER()))
- Is there a way to rollup values of a custom column to a parent and other hierarchical parents without using the SUM function in each parent row? For example: I added columns A, B, and C. Column C = A …
- Hello Smartsheet Community! Happy Monday! We released some new features over the weekend. Below is a description of the new features and relevant help content to learn more:* Three New Functions:* SMA…
- I need help finding the right formula. I have basic Gantt with four phases, each phase has tasks associated with it as well as durations. I've set a "start date" column and by using durations for each…
- Is it possible for start date of a task to be based on dates tied to one of two other tasks? E.g. Task 2 must start not more that 10 days from completion of Task 1. Under normal circumstances, this al…
- I have a multi-user sheet. 4 column with to-do tasks. When tasks are complete, the user put their initials in the box. At the end of the column, I have a formula that adds up the initials and the cell…