-
IF(CONTAINS Formula - if adjacent cell contains text, reference cell in another sheet, else blank
I have a sheet where I want to list the client name from a separate sheet in column 1, if column 2@row contains text. Otherwise, leave blank. Currently I have it written as: =IF(CONTAINS("*",Activity@row){Other sheet range 1}," ")) where Other Sheet Range 1 is the specific cell with the client name. It's not functioning,…
-
Using Countifs with multiple references to other sheets
Been playing with this for a while but can not seem to get this right. Any help would be appreciated =COUNTIFS({Editing List-3-2018 Range 2}, >=(DATE(2018, 7, 1), {Editing List-3-2018 Range 5}, ="Name"), Date:Date, <=(DATE(2018,6,30), [Assigned to: Editor]:[Assigned to: Editor],="Name")
-
Trying to use SUMIF to Sum one column but only of the items in another column
I am trying to get the SUM of SaaS Value if the value in the Backlog Status column is Active Backlog. Tried this and I am getting unparseable SUMIF([Backlog Status]:[Backlog Status],”Inactive Backlog”, [SaaS Value]:[SaaS Value])
-
Use AverageIf to do turnaround time?
Hi, and thanks in advance for reading/helping. We're wanting to display up-to-the-minute turnaround times year-to-date for responses to entries. Some of the rows go back into 2022 and should not be shown as part of our metric. I am trying to use a sheet summary field to show the current average of response. I have the…
-
Convert Measure Symbol to number & Average
Hi, Since my team has selected the pain scale symbols as their preferred method of scoring work, here I am struggling to make the following formula work. =IF([Value to User]@row = "No Pain", 4, IF([Value to User]@row = "Mild", 3, IF([Value to User]@row = "Moderate", 2, IF([Value to User]@row = "Very Severe", 1, IF([Value…
-
Linking Smartsheets
Hi, first timer here... So I'm using Smartsheets to track issues that are identified on a particular system so that I can maintain a count of those issues using a single sheets. All well and good. Now, I need to (I'm thinking in a Separate sheet) track the MONTHLY issues. For example, April I tracked 10 issues, and in May…
-
If Match Check Box
How do I write a formula to check a box next to an ID Number if that same ID Number is also present in another column? So Column 1 is ID Number to complete and Column 2 is ID Number completed list. Thanks in advance!
-
Can I have one section of a formula check two different sheets?
So, here's what I'm trying to do. I have three sheets in total I'm working with. All three sheets contain a unique identifying number for easy reference. Sheet A = Master sheet which is where the formula is housed. Sheet B = Sheet with usage data for site 1. Sheet C = Sheet with usage data for site 2. Both Sheet B and…
-
Crosssheet checked box count
I have Sheet (A) I want to you as a summary sheet for Sheet (B). I want sheet (A) to count howmany checked boxes are in a specified column in sheet (B)
-
COUNTIF Formula Providing Incorrect Result
Hello! I am adding sheet summary fields to count the rows for each status. I noticed that the results I get with my COUNTIF formula are incorrect. The correct results would be: Completed - 3, In Progress - 1, Not Started - 2 (this one is correct) I tried this formula on a second sheet and still received an incorrect…
