-
In need of a formula that takes the amount in the Children rows and divides by a Parent row total
I am in need of a formula that takes the amount in the children rows and divides by a Parent row (ideally would make a column formula). My current formula for the attached is the below (one of many formulas tried). =IF(CHILDREN([Merchant Revised Casepack Quantity]@row > 0, [Merchant Revised Casepack Quantity]@row /…
-
Pull value from cell to a new cell, and it won't change even if source value changes
I will use the following as an example for my problem: I have a pre-existing sheet ("Team Employees") where different teams record their # of employees once a month. This was used to track live staffing. The request is now to track overtime. My question is this: Is there a way to pull the # OF EMPLOYEES for LOGISTICS from…
-
Need a better Sheet Summary Formula - (Collect/Max & Index/Match)
In my example, I am able to return the top Sales for an item based on certain criteria for a Sheet Summary formula (Shirt Top Sales) with =MAX(COLLECT(Sales:Sales, Product:Product, "Shirt")). I am also able to return the Color for the Top selling Shirt (Blue) with a formula using the previous summary value in the formula:…
-
Need another set of eyes on SUMIFS formula in Sheet Summary
Hi and Happy New Year, Hope all is going well for you. In the Project Intake Sheet, I'm using the Sheet Summary to calculate metrics for reporting. On this particular formula, I keep getting #UNPARSABLE. I haven't been able to figure it out all day. Appreciate any input you may have! Goal: To sum the values in the ARR…
-
If statements with currency positive and negative and needing value
I'm having to try to create several formulas so that I can in turn create triggers. I need to say if there is a value in cell A with a difference of $1 (positive or negative) from cell A and cell B I want it to say notify, if not say no. Anyone have a suggestion. I had =IF([Cash Distribution (AM)]@row - [Received Cash…
-
Health Icon Formula Help
Hi All - Longtime lurker, first time poster. I am attempting to add a Health Column to a smartsheet created by a colleague. I have been in the forums checking answers to similar, and tried to kluge my own formula together, but I've either missed the logic or I'm trying to do too much. What i'm trying to achieve rollup…
-
Move child row under new parent row when a cell value is changed.
I have parent rows (upcoming week, current week, and past weeks) and I'd like to be able to change the status cell from upcoming week to current week, and have it move the row under a different parent row. Is this possible?
-
How do I copy the info from the cell above if criteria are met in another column?
What I would like to do is create a formula that will copy the information in the cell above it if the 'X-code Details' is chosen in the pick list in the column next to it. If General Run Details is indicated, want the entry to remain. I know there has got to be an easy solution to this, I just can't find it and AI is not…
-
Help on formula: count if with multiple criteria
Hi all, I'm trying to get the count of active projects in my tracker sheet however I'm getting zero as a result. Please, can you check and advise what should be the correct formula? Here's the formula I used: =COUNTIFS(Stage:Stage, "planning", Stage:Stage, "strategy", Stage:Stage, "tender", Stage:Stage, "evaluation",…
-
COUNTIFS question
EDIT - I think I solved my original problem by removing the <> before the "2099". However, how do I write the formula to show not equal to 2099 without using an operator? SS doesn't seem to like it when I use <>. ******Hi, I've browsed a number of the COUNTIFS posts but for some reason, I can't get my formula to work. It…