-
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…
-
Graphs on Dashboard not updating dynamically
I have an issue with the charts on my dashboards not updating to show current metrics. Not sure if I am doing anything wrong but here is what I have done. 1 - Created a sheet and linked data from a Card that i have setup for my team 2 - Columns now show with Assigned to and status, I added a countif formula to count all…
-
Formula help
Hello, I am trying to do a vlookup on my smartsheet task list to reference a different smartsheet which looks up for example "312" returns the value two columns over, which is a date, and then minus 90 days from that date and returns that date in the cell. Is there a way to do this?
-
Nested IF and OR (and possibly AND)
Hello, I have two checkbox columns: one for Arabic and one for English. These columns will either be checked, unchecked or say "n/a". What I want is to have another checkbox column where it is checked if Arabic and English are both either checked or "n/a": for example: IF Arabic = 1 OR “n/a” AND IF English = 1 OR “n/a”,…
-
Beginner Formula Help - Extract Text from different cell
Hi, Please excuse my beginner's questions. We are starting to use scanning QR codes into smart sheet. Currently our QR code translates to the below text, where important values are delimited by "|" symbol. When the below text is inserted in one cell, I'd like to create a formula that will extract the text after the…
