-
Help with my formula
I am not the best at formulas and need some help. I cant seem to get my head around building formulas. Anyway can someone help please. I am trying to build a formula that will count all the true BOOLEAN in the children row and when it is greater than 4 return the a true outcome to the parent row. Hoopefully someone can…
-
"If clause" in Dependancies
Hi all, I am struggling to find a solution for this. I have 15 individual sheets for a project. One of the activities on sheet 2 will include a "yes/no" question. If yes, then sheet 3 needs to be completed. If no, then sheet 3 will not be necessary. I can't see an efficient solution for this. Any suggestions? Thanks!
-
RYG Ball Automation
Hello Community, How do I go about writing an IF function to get a particular cell to automatically show Green when the child rows turn Green individually? Basically, I would like to see the parent row update green without the need to do it manually each time I change the status of an individual cell. Thanks!
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
RYG Status Formula
We have two set of data that are required. Count column that is 0 until there is entry into one or all of the previous columns. This formula provides a count (this formula works fine) =IF(Series5 = 0, IF(COUNTIF([SKU 1]5:[SKU 15]5, "") = 0, 1, 0), 1) In the RYG column I have this Formula. =IF(Count5 = 0, "Green", IF(Count5…
-
COUNTIF Function
I'm trying to count everything in a Type column that = "Risk" that match a status of "Red" and "Yellow". How would I add "Yellow" to this statement? =COUNTIFS(Type:Type, "Risk", Status:Status, "Red")
-
IF function combined with Vlookup in 2 different smartsheets
Hello! I have another beginner question. Is it possible to combine an If conditional with a Vlookup? This is my scenario: I have 2 sheets: Summary and Form. Columns in each sheet are: Summary Sheet: -Column Name -Column Question #1 Form Sheet: -Column Name -Column Quarter -Column Question 1 The result that I need: I would…
-
COUNTIF Function
Im trying to count 2 columns on a issue sheet and want to count out each specific type (Risk, Action, Issue, Decision) that are open (not counting the closed or in progress types) I have these formuals but its not producing a result * =COUNTIF(Type1:Type50, "Risk", [Status1]:[Status50], "Open") * =COUNTIF(Type1:Type50,…
-
Error With % Complete Child Roll-up caculation
Hello, My team has requested that we use an average % complete of the child cells to populate the parent cell. I am struggling to get this to work. Does it matter if you are rolling up % complete that have already been used in a average formula? For example Task 1 % Complete is calculated by averaging % Complete for Task…
-
Extract selected data from sheet (without using report)
Hi Smartsheet community! I have the following problem: I have a Smartsheet with a long list of items. These items will be shipped in several shipments and several collis, on different dates and to different locations. I would like to extract an shipment overview from this complete list of items that only includes the…
