-
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…
-
Combining AVG/COLLECT/NETWORKDAYS
I am attempting to calculate the average number of working days it takes to complete a request, Criteria I want to base the data collection on include: urgency level Month and Year(I created a rolling month chart to see trends-see below screenshot) The Work Completion Date determines the month it will be reported on This…
-
Text To Column
I need help taking this string of text and creating column for each unique number sequence that is separated by comma. I was able to do the first column, but I'm unable to figure out the rest. Any help is appreciated.
-
can i use index collect to find a value based on a date?
through use of a form i have a sheet that will create rows with certain departments and issues they've encountered. i have a master sheet that i want to populate with the most recent issue encountered. My thought is the first find the max date for a department and then use index(collect to collect the first issue that…
-
Conditional Formatting Comparing Dates
I want to have conditional formatting comparing 2 dates: Where [Actual] > [Due Date], column will be red Where [Actual] < = [Due Date], column will be green Where [Due Date] has a value but [Actual] is blank, I would like to assume today's date for Actual. Where [Due Date] is blank, but [Actual] is not, I'd like it to be…