-
SUMIF - Circular Reference?
Hello all! I'm pretty sure I saw this functionality in one of my Engage sessions, so I'm crossing my fingers that there's a simple fix! I'd like to create a form that would allow individuals to submit project-related expenses for approval. I envision having a list of project numbers at the top of the sheet (see image, with…
-
Add a column showing the ParentID (or SiblingID)
Hi all, Is there a way to add a column which displays the ParentID to a Smartsheet? If I had this, I could produce the report I am trying to build I expect. Hep appreciated! Thanks, James
-
Notification with attachment
Hi, I have already set up the notification. In my Smartsheet, there are a few columns. One of column is "Mail Out". In this column, pre-set has two answer only: yes , no. In each row, there is an attachment of that specific building word file. So, as I create notification, if mail out column is "yes", email to mail room…
-
Show Value Sum of total Parent Rows checked.
I've researched this and cant find a solution. How can I set up a CountIf formula for ONLY if Parent Rows are checked in an entire sheet? I can do this for the children rows but cant figure out how to do it only for Parent rows. Also, Can I place this formula on the checkbox column (at the very top for a total) and show a…
-
How to compute Average Ratings on a Subset of Rows
Trying to put a formula that will compute the average rating based on organizational grouping. I have a smartsheet that has a drop down field which includes organization functions like: engineering, IT, Sales, Marketing, ... I have another field that is a numeric rating for these organizational functions. 1 thru 5. I need…
-
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()))
