-
Averaging RGB balls
I'm hoping this is quite simple, but my simple mind is struggling to piece it together. I have a Parent Row with multiple Children but only one hierarchy below it and i want the parent row to average the status of the Red, Green and Blue balls on the Children rows...make sense? Help would be much appreciated, screen shot…
-
3+ Levels of Filter Groups
I know I've seen this filter setup before but I cannot seem to recreate. I am trying to layer 3 or more filter groups to attain the desired logic. Is this feasible?
-
Unwanted Default gray background of the dropdown selections
Hello, I am trying to change the backgound color of the Dropdown selections that appear in the cells to white. Is this possible? is there any CSS formatting i can give to the background of the dropdown selections? I would like that gray background gone please
-
Sheet to Sheet with Parent Rows
I have created a sheet that when a check box is marked it moves the entire row to another sheet. I was wondering if there is a way that when the row moves to another sheet if I can have it populate the information under a parent row? Example my Scheduling sheet moves the row to my Machine sheet. My scheduling sheet I make…
-
Formula to update status on a parent row based on child row with OR statement
Hi - I need a formula to update the status on the parent row based on status values in the child rows below. I am wresting with this formula and hoping someone on here can point me in the right direction. I found this post which is exactly what I'm looking for but there was never an answer to her last comment about needing…
-
formula handbook for EU region
could you give access to the formula handbook to all regions? Thanks
-
Need help with a VLOOKUP formula
Hi all, Just to be upfront, formulas are my Achilles heel, so I'm not sure if I'm doing this right. My company has a Lucidchart training coming up, and we've created a sheet/form that will list out everybody who has filled out the form and has expressed interest in the training. I've also imported another sheet that lists…
-
Looking for solution to "Parent vs Ancestors" problem
Hello, I have been having tons of trouble coming up with a formula that will give me the desired result. The goal, it to populate a column with two pieces of information from other columns. In the attached image, the column "project name and header" is supposed to take the ancestor of SLS Job Number and the ancestor of…
-
Standardising imported date formats
Hi, I hope you are all well, and someone may be able to assist: On a sheet I am working on, a 3rd party app runs an automation that imports a date into a specified column in smartsheet. The date when imported arrives in the following format: "2023-01-04 12:26:14". There is no way to change the format which this date is…
-
Is there a formula to calculate years, months, and days between 2 different dates?
I found a formula that calculates the years and months between 2 different dates, but because it's not also calculating the days, it is rounding up the months which isn't going to work in the case that I need it. Here is a picture of what I'm looking for (how many years, months, and days) Purchase Date to Expiration Date.…
