-
List of reports and sheets used in dashboards and sheets in reports
Is there a way to generate a list of sheets and reports that are used in a dashboard? If not a report, is there somewhere: In the sheet that will show it's used in a report or dashboard In the report that will show it's used in a dashboard or that it uses a sheet In the dashboard that will show it uses a sheet or report
-
How to count individuals in multi-contacts separately?
I'm working on a formula for project allocation. I'm extracting my information from two columns in another sheet, master tracker. The columns from the master tracker are Status and Project Leads. In the sheet for Project Allocation, I'm using the following: The Columns are the Status and Person 1, Person 2, Person 3, etc.…
-
Flagging a Date and Time Overlap Across Multiple Days
Hi all, I need some help with a formula which I believe I almost crack but I don't know what I'm still missing here, I want to flag overlapping tasks across multiple days and times, as you can see below, I have different columns: Start date, end date, start time, end time. Start and finish are just switching the time…
-
Capture the date a sheet was created
I have a sheet that I create for a review process - new sheet for each review. If the sheet is still open after 2 weeks, I want to do some actions - email the assignee etc. How do I capture the sheet creation date so I can add some automation? I know I can do this for cell dates but not sure about the actual sheet. Thanks.
-
Column border style
Hello! Just a simple idea that might be interesting for other users. When you have many columns with different categories, there is no simple way to make a visual distinction that allows you to "group" data vertically. So far, what I'm doing is to create a "fake" border using an empty column with background color. This has…
-
How can I use one sheet to build onto another and still be able to manipulate the data?
I am pretty new to Smartsheet, and my office would like to account for requests using Smartsheet. There are two types of requests: Original and Supplemental. Supplemental requests build onto original requests. Therefore, if someone wants to request the same individual, they will submit a supplemental request because an…
-
Automations when selecting from contact dropdown
I created an automation to move rows to a specific person when they are selected from a contact drop down. I have more of these to building, with different automations such as copy a row when they are selected from an other drop down. I also need to add a notification when each of these process have run. I attached what I…
-
Auto checkbox formula when cell contains multiple values
Hello! I am trying to create a formula that automatically check the box if the "Year upgrade or addition" cell contains the year 2012 or later. In my screenshot, you can see this cell contains the years 2007 and 2016. Since 2016 matches my criteria, I need the ADA Complaint? column to be checked. I tried =IF([Year upgrade…
-
Flagging a Date and Time Overlap
Hello, I have a situation where we teach virtual classes that are each approximately 2- 4 hours in length, start and end at various times each day, and each requires a unique conference phone line dedicated to the class. We can teach as many as 6 to 8 classes in a day, but only have 4 conference lines. I'm trying to write…
-
Recreating Report in a Sheet
Hello! Our team has a financial tracker and our timesheets in Smartsheet, and I am trying to find a way to link them. The goal is to take the number of hours worked on each project, and multiply them by our average rate to get a rough estimate of our current labor cost. Our reporting also needs to separate time between our…
