-
Sum Children formula
Hi all. I am having an issue with getting a correct sum from children of a parent row when using a formula in the children rows. Ex: Children row formula is =IF([Date Completed]43 > [Due Date]43, "1", "0") There are two children rows; the formula above creates a 1 and a 0 respectively, however, my =SUM(CHILDREN()) formula…
-
Email recipients from automation
Is there a way to view the recipients of automation email when you have Editor access to a sheet?
-
Advice: Looking to create a Global Onboarding SmartSheet
Currently our organization uses 3 separate sheets (one for each region) to track the status of onboarding our new hires. We capture things like: New Hire's Name, Start Date, who the offer letter was assigned to, when the OL was created, Drug Screen information, Background check information, etc. I would like to combine all…
-
sort in report
i have a repotr based on sheet with ~1500 rows (parents and children). as i know there is no way to show the parent and children in repost so that i mark in color the parent and sort the report to show the parent and children. but, now i want to sort with another level: i want to show in report the parents row and…
-
Counting open tickets based on company name and ticket status
Hi, I'm trying to count the number of open tickets by company name, and the cells I'm referencing are in another sheet. Here's my formula so far: =IF({Maintenance tracking Sheet Range 2} = [Company Name]@row, COUNTIF({Maintenance tracking Sheet Range 3}, {Maintenance tracking Sheet Range 3} = "Open")) But I'm getting an…
-
Convert Symbols to Numerical values
What is the formula to convert the bar symbols of Empty, Quarter, Half, Three Quarter, Full to numbers? For example, Empty = 0 Quarter = 1 Half = 2 Three Quarter = 3 Full = 4
-
Color Coding for Names / Owners only
I'm trying to find out if I can color code only the name bubble. For example, below I'm using the multiple-drop down column formatting and all names are shown in grey. It would be nice to show Whitney in purple, and Laura in yellow, so that they can quickly see tasks they are assigned to. Right now, I can only set a…
-
RYB Automation Question
Hi, I am looking for some assistance with automating the RYG Status Balls in my Sheet. Below is my data, and I am attempting to key off the "smartxpo launch date". What I want to do is assign a Red, Green, or Yellow status ball with the conditions below. IF the SmartXpo Launch Date is between 100-90 days, then assign a…
-
Help with an existing RYGB Formula
Below is the current formula in a RYGB column. In the current set up, if the status is "not started" but the End date hasn't past, it will be yellow. Which is fine, however, I would like to update the formula to ALSO take into consideration that even if the status is "in progress", however, the % complete is less than the…
-
count tasks per week number
Hi community, I'm trying to count the tasks in my gannt per each week in a separate grid. Then i'll make a graph representing work overloads throughout the year. Here is my formula that calculate 0 every time (at least not an error) : =COUNTIF({6530 - Sulfuric project Schedule Range 5}, WEEKNUMBER({6530 - Sulfuric project…
