-
Dashboard Card View with persistent filters
I have a dashboard with two web content widgets of the same sheet using a card view. I want to be able to have one only show the completed cards and have the second only show the in process cards. I have successfully created filters that can be used but I don't want the viewer to have to select the filter. I would like the…
-
Is there a formula in smartsheet that would create a 2 way link between cells?
Hello, I have multiple sheets that I would like to link all into one Master Sheet. I want the cells to have a two linking methods between each other. If a cell changes in the Master Sheet, I want it to reflect to the other sheets and if the other sheet decides to change the cells, it would reflect back to the Master Sheet.…
-
Budget v. Invoice Cost Codes
I have two Smartsheets. Sheet 1 is my budget broken down into various cost codes. Sheet 2 is a log of all my invoices with cost codes and amounts assigned to each invoice. I am trying to take the amount from each invoice and have them populate in my budget according to their cost codes. The budget amounts for each cost…
-
Trouble with COLLECT in INDEX/MATCH
I'm trying to troubleshoot an INDEX/MATCH formula that contains a COLLECT statement which is supposed to limit what cells are being used for the MATCH. I am referencing a project schedule, looking for the "next deliverable" - we have a column called "Function" in which the schedule tasks can be defined as such. (See…
-
Calculating costs for a task over more than one month
I'm trying to come up with a formula to calculate the labor costs per month in one sheet ( 12 columns, one for each month), by referencing another sheet, and referring to the start/finish columns of said task. E.g. Task 1: Start = Aug 27, Finish = Sept 5. So in my cost sheet, the formula needs to refer to the start date…
-
Using IFS statement with date and check box
The simple statement is I want to have a sum of work hours in a department, that is still incomplete, during a calendar period. Currently the formula is: =SUMIFS([Work Hours]:[Work Hours], Department:Department, "Wire", Finish:Finish, >=DATE(2020, 9, 1), Finish:Finish, <=DATE(2020, 9, 30)) * 8 A suggested version has been…
-
How to efficiently link data from one sheet to two other sheets
Hello, I'm trying to link data from a master sheet to two other sheets. Here is what I tried so far, but it's not working. Created a form on the Master Sheet. Tried Cell linking the master sheet to two other sheets. However the problem that I have is that because I am already using cell linking on this Master sheet to feed…
-
Auto populating status
Hi I've created a new smartsheet to track submissions we're making to an outside authority and what stage the are at. I have a new line for each submission then a column for date the submission prep started, when it was submitted, when it was validated and finally approved. I'd like to have a column right at the beginning…
-
Referencing a cell on another sheet based on information in its' parent
Hi everybody, been melting my brain trying to get this one I have a bunch of project sheets set up to send their rows back to a central tracking sheet. I have a Master Status sheet that parses that tracking sheet for each project. It looks up a unique project ID, parses that central tracking sheet for the latest row with…
-
Duration to a specific task from project start / counting the number of project days
Hello, I'm wondering if there is a function in Smartsheet by which I can create a column that displays the total number of project days from the beginning of the project ("Project Day 1") up to the beginning of each task. For example, the first task would start on "project day 1," the last task of the project would start…