-
Formular to add up qtys from another sheet
Hi Guys I have a main smartsheet with all my products and current stock levels on, and another smartsheet which has all the product movements and quantitys, this sheet will be the one users update What I need is for the stock levels for each product on the main smartsheet to update based on the movements file. In both…
-
Smartsheet Updates
I am curious what other users would think about this. I was working on a project recently and worked out the formulas in Excel since that is where I have more experience. Got everything worked out and it was awesome, and all the formulas worked well within Smartsheet, besides one. The one formula that did not work was an…
-
Line Charts in Dashboard not displaying data - requires save to display?
I've built numerous dashboards and have never encountered this error previously. i have a formula: =AVG(COLLECT({Material Requests (Draft) Range 10}, {Material Requests Range 1}, "1", {Material Requests Range 2}, "2024", {Material Requests (Draft) Range 3}, "Central")) This results a figure (0.39) and when I go to chart…
-
Circular Reference
I am working on a RAID log and want the "Next Action Owner" column to be filled in with the name in the "Created by" column if people do not add a name in the "Next Action Owner" column. Is there a way to edit the formula that I currently have in the "Next Action Owner" column to have this done without receiving a circular…
-
Building a Dashboard off of my Status column
So I am want to build a dashboard that will track/show how many complete, not started, and in progress tasks I have. I have four separate sheets that I will be doing this with. Each having about 8-12 tasks that will be tracked. The problem is which I will share below is under each "Task" I have a Indent where committees…
-
Auto Changing Drop down list
is there a Formula that would Make a Drop down list of items change to the right info if x amount of checkbox are clicked? looking for something like this in the drop down list "locked" Ready to Order Pre Fab Ready to Ship Site Lay Down Area Staged in Work Area Being Installed Complete and check boxes for Staff to click.…
-
MIN(INDEX(COLLECT on a Multi-Select column
I'm hoping I can explain this so it makes sense. We have a Requisition Tracker that tracks the needs for new hires in new buildings we are implementing. Often the employee can be used in more than one building. The building Go Live Dates can differ - the one that is important is the earliest one. Is there any magic out…
-
Cascading timelines by linking timelines
I have three grid sheets, named Sheet 1, Sheet 2 and Sheet 3. The timeline of Sheet 2 is dependent on Sheet 1 timeline and the timeline of Sheet 3 is dependent on Sheet 2. I want a function wherein if the end date of any one task of Sheet 1 gets changed then it automatically changes the start date of the task of Sheet 2 or…
-
Help setting up a daily tracker
Hello! My team is attempting to create a sheet and form that counts the amount of inventory of a product we are overselling per day. We essentially would have the inventory start with 15 units per day, we are going to request the number they sold for each entry. The goal is to have the number they enter in the form will be…
-
How can i make an automation to notify me 2 years before a due date?
I have a due date (e.g. 28/10/2027) and id like to be notified 2 years before the date. As smartsheet only allows me to set an automation 365 before a due date, I made a helper column which would bring back the date i should be notified. I used the formula below but i get an error. =DATE(DAY([Due Date]@row), MONTH([Due…
