-
Index Collect Question
I am trying to use Index Collect for the following - and I am stuck :-) In the column "Validation NL" (upper table) I like to display the value of the column "Jira Status" if the value in the column "Epic" = "GBT-704" the value in the column "Req ID" matches the value in the column "MMP ID" This is the formula I tried but…
-
Having trouble with an Index Collect with multiple matches?
Hello all, please let me know if this makes sense what I am trying to accomplish as I have been stuck on trying to get a fix for this. I am working to create a sheet that looks at an export out of a dsp and checks to see if those are elements match with the information in our smartsheet - kind of like a QA sheet to do…
-
Global update - cross sheet formula needed
Hi All, While doing a global update I added new column ( type: Contact) I need to change the formula to that column. The issue is the formula is cross sheet =IF({Project Metadata (Do Not Edit) Range 3} <> "", {Project Metadata (Do Not Edit) Range 3}) it is meant to pull a an email address into the column from a different…
-
Hi! This one might be tricky... Help with T-Minus Formula *First time posting!*
Hi! I am basically looking for a formula that will return me a "T-2" result. For example, a product is launching on 12/31/2025, and XYZ activity is taking place 01/31/2025. Ideally, the formula would tell me it's T-11 from the launch. Does anyone know how I could solve for this?
-
Form Submissions: Multiple Condition IF Formula Isolated to Most Recent Only
Hello Friends! I have a form that my field crew uses to check the condition of our machines every morning, which includes the most recent hour/meter reading. There are (5) machines that we own that I want to isolate the most recent reading into a dedicated cell in order to determine how soon the next service will be. Also,…
-
Count number of tasks by day to know how many workers are needed
Hi Everyone, Brand new to smartsheet and I have very little understanding of it's capabilities. I've built an extensive gantt chart with tasks going out over a year. When I manually count the tasks, I can see that I need anywhere between 2 and 5 workers on a given day based on the number of active tasks. As I continue to…
-
Is it possible to remove a cross sheet reference when a condition is met and keep the data?
I have an interesting scenario where I have a cross sheet reference that pulls a current outstanding total from another sheet. This works perfectly but we want to keep history of what this total outstanding value was at the end of each day. The image below should help explain the scenario. Essentially what I want to do is…
-
Formula not returning the correct values
I'm having a bit of a weird issue. I have a helper column that is supposed to return values that are pulled for a metrics sheet. Overall the formula is working, but it's like its not moving past the "Materials Delivered to Vendor" part. =IF([GM Status]@row = "PO Created", "Written", IF([GM Status]@row = "Delivered to…
-
I need help rolling up multiple weeks of data into one response based on specified criteria
I currently have a sheet that collects weekly attendance info from multiple stakeholders (for the purpose of this question we can just look at the Coach Info columns). There are 3 responses that can be put into this column: 'Yes', 'Some, and 'None'. My second sheet is a monthly tracker in which I am trying to read four…
-
#NO MATCH result with INDEX/MATCH formula referencing Auto-Number/System
I use the INDEX/MATCH formula across many of my sheets for many years. This is the first year I've encountered this issue: my formula is indexing information referencing an auto-number system column type. We generate 3-digit "reference IDs" in this auto-number column to make it easy to index information for that respective…