-
Fill formula's with Zapier
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 upportunity is accepted in our CRM system. However, the autofill formula functionality does not seem to work whan creating a new…
-
Formula: Look Up for two value
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 is Apple , [Brand]1 is XYZ Ltd. [Price]1 is 50 [Fruit]3 is Pear, [Brand]1 is ABC Ltd. [Price]1 is 100 I want to have formula…
-
Formula: Remaining Work based on Any given Date
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 today's date Thanks
-
Identifying children for a specific parent automatically
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 without having to identify the children under the parent. I can use =avg(children()) but I will need to specify the children cells…
-
Embed hierarchy function as the range within the COLLECTION function
I amy trying to execute the following function. Does anyone know if it, or something like it, is possible: = AVG(COLLECT(CHILDREN(), CHILDREN(), ISNUMBER()))
-
Parent Row Rollup
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 * B. Is there a function or some other way to sum up column C to a parent row? Or do I need to use the SUM function in the…
-
New Functions and Notification Controls
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:* SMALL—Find the n-th lowest value in a range. * LARGE—Find the n-th highest value in a range. * COLLECT—Used within another…
-
Count down in days formula
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 task and predecessors I then have the calculated "finish date" column for each tasks and each phase. I need to create a…
-
'Conditional'/Multiple Predecessors
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 allows task 2 to start not more than 10 days from start date of task 3. If start date of task 3 must be accelerated, however,…
-
count text occurrence in a check box column
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 fills in a "YES" for all complete or stays "NO" if not all complete. At any given time, there could be 75-100 of these…