-
Formula to count workdays if certain criteria is met
I have a sheet that is tracking open tickets. In this sheet I have a column that is counting net work days since the ticket has been opened (=NETWORKDAYS([Created Date]@row, TODAY()). I would like to have the column only track networkdays if the ticket is in any status other then Complete or Closed but I keep getting an…
-
IF formula to identify tasks for this week - missing tomorrow
Hi, I am using the formula below as a column formula under "This Week" to check the box when the start or finish date falls within this week so I can see which tasks I need to be working on week by week. It is capturing it correctly except when I have a task that starts and ends tomorrow (one day duration). How can adjust…
-
dashboard formula to show completions in last 30 days
Good afternoon, I am still a bit new to smartsheets. Would someone be able to assist me with creating a formula that shows how many requests have been submitted within the past 30 days? The goal is to use this on a dashboard so that any date you go on it will show the correct data for past 30 days of submissions. I am…
-
Recurring Cleaning Schedule Setup
I'm helping my Laboratory Department setup a Tracker for a Cleaning Schedule that has a variety of pieces of equipment that each have a different time range of when they need to be cleaned (from every 2 weeks to 6 months). I had it in my head that I could use Gannt functions to setup the varying Durations of each piece…
-
Smartsheet Formula to Click Active Checkbox in Next Row when Complete is Checked in the Row above
Title says it all but I'm putting together a workflow using hierarchy. We have certain tasks that have 6-7 phases in them before they are complete, and other tasks that only have 1 thing to do when they are complete, and I'd like to build an automated formula to check an "active" checkbox if something is a child row and…
-
Copy the value of a cell when columns contain certain text
Above is my reference sheet. On a separate sheet I need to create a formula that returns the value in [Count] when the [Org] = "MSCL", [Type] = "M", and [Metric Category] = "01 - Active". This reference sheet will be uploaded in data shuttle monthly and the data I'm looking for may not always be in the first row. I'm new…
-
If statement for a Modified Date column WITH the time in the cell
Hello again community! I am trying to write a if statement formula where if a certain cell in the sheet is blank it will show the modified date column. Below is the sample of the formula: =IF(NOT(ISBLANK([Sample]@row)), Modified_date@row,"") This formula works great when I set the column formula to a Date column. However,…
-
Counting a column with multiple selection and Dates per month
Hello, I am trying to reference another sheet to count the number of times the following "Other, NA, and Blanks has been entered per month "Example for July, August, etc". Any help would be greatly appreciated. "Example Other, NA, and Blanks"
-
Index match Help on formula
Hi All I have an index match formula that pulls info from another sheet from a status column made up of a drop-down with fifteen values. This is restricted to values. When I find the corresponding match, the formula works great, but if a value is not found, It returns a default value, which is not specified. I would expect…
-
I NEED HELP GET THE smartsheet equivalent to excel formulas
Formula A =IF((OR(B8="K",B8="PO", B8="", B8="via")),SUMIFS(Contract!R:R,Contract!E:E,C8,Contract!F:F,"0"),"NA") Formula B =IF((OR(B10="K",B10="PO", B10="", B10="via")),SUMIFS(Contract!R:R,Contract!E:E,C10,Contract!F:F,">0"),"NA") Formula C =IF((OR(B9="K",B9="PO", B9="",…
