-
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…
-
row sorting is juggling formula
We have created a sum function in a row that has been copied down for 100 rows. We are only reading data from each row......not holding a cell from a previous row. When sorting and filtering throughout the day, we are finding that the sum functions are trying to read previously held row designations. Row 10 may read the…
-
IF formula combined with dates
Hello, I need help. I am wondering how can I create a formula using the IF function with a range of dates. For example: If the date is between 01/01/2018 and 03/30/2018, then write 1st Quarter., and if the date is between 04/01/2018 and 06/30/2018, then 2nd. Quarter, etc.... Thank you in advance!
-
COUNTIFS / Referencing data another sheet
I'm still pretty new to Smartsheet. My goal is collect data from another sheet in an easier to read format but I cannot get my COUNTIFS formula to work. If I do separate formulas for each criteria it will work but not when I attempt to combine the formulas to look at 2 criteria's it fails. I have columns on the referencing…
