-
Index & Collect Using Date Range
Hello, I'm trying to return cell values from another sheet based on a date range in a date field but I can't seem to get the formula to work. In a new sheet, I want to return the value of a specific cell from a different sheet based on the date range (3 months prior to today) field. This is what I tried and it doesn't seem…
-
Countifs with Row Reference
Hello I have about 100 lines of Primary data in a column that will reference another sheet that I am summarizing. I am trying to create a COUNTIFS formula that will use the Row Reference for the Primary Column to count column data from the other sheet and allow me to copy the formula down. My formula is fairly simple…
-
Automating a daisy-chain of tasks with Updates and Status
Currently stuck trying to automate the completion of one task to trigger the next. The situation: All data is on one row per project. Each task is listed there and on its own sheet. And everything needs to work through Update Requests. No one should be touching the raw data on the Master Sheet. Form submits a new row on…
-
Possible bug: Smartsheet adds a trailing space to random cells
I've encountered some strange behavior where Smartsheet automatically adds a trailing space to a cell. Below are two columns. The right column adds a "|" to the value in the left column. You can see that in the penultimate row a trailing space is added to the cell: I am using the COLLECT function to show the contents of a…
-
Is it possible to automate link creation between 2 smarthsheets?
Regarding the question above, consider a scenario where 1 project requires 2 linked smartsheets. Now consider a scenario where 50+ projects each require 2 linked smartsheets and a new project is added to the que 2 or 3 times a week. Is it possible to have two "master" smartsheets linked to each other that can be copied and…
-
Help With Index Match (#Invalid value)
I am trying to return a Contact value Cell from a lookup table, in the Column "Assigned Contact Email" according to "Week * + Day*" and "Shift Assigned To" in that Row This is what I want it to look like. ^ This is the other sheet with the look up table. ^ This is the Formula I have used. ^ ^ For the formula, Red is the…
-
Updating references on a template and deploying changes via SCC
Hi all, I am trying to update an existing metadata sheet in our solution build via SCC. I was able to make the changes on the sheet itself and have applied it at the template and test with an existing team dashboard. I realized after I will need to use SCC to actually make the change and then to all the retroactive sheets…
-
Hierarchy issues
Hi everyone, I have been pursuing the forum but I can't seem to find the answer. For some background, my company had a team that set up our Workspace and sheets. One of my coworkers was also the admin but recently left for another job. I have been tasked with taking over admin/owner duties now. I understand the basics and…
-
COUNTIFs formula with Date Range
Hello, I am trying to create a monthly trend report. The report function is not specific enough for what I need, so in order to do this, I have created a metrics sheet that references 21 different originating sheets. To fill my metrics sheet, I need to use a COUNTIFS formula to reference a date range. I've tried it a few…
-
How do I automatically pull a value from a cell in one sheet into another sheet?
Hi. I have two sheets: Sheet 1 - a Work Order Submission Log Sheet 2 - a Project Log When a work order is submitted to Sheet 1, a Work Order # is generated in the Auto-Number column of that sheet. Each Work Order # is unique, but they all have the same suffix ("_wo"). I would like the Work Order # from Sheet 1 to…
