-
Column management
It would be great to have a place to see / edit column titles and attributes. Maybe this already exists, or the idea has already been posted, but I couldn't find it. I'm also sure I'm going about it the wrong way, but what made me think of this is: this morning I was working my way across a sheet changing the name of about…
-
Does activity show on the underlying sheet if someone accesses a dynamic view?
I have created a sheet that I have built a report off of and then built a dynamic view off of the report. If someone does not have access to the sheet will their activity still reflect in the activity log if they access the dynamic view? The person does not have any permissions to the workspace where the sheet is located…
-
Formula Help! VLOOKUP searching through a multi-select dropdown
I keep trying different variations and can't find it right: The formula that I used which is close would be =VLOOKUP([Item ID Number]@row, {Adult Sponsor List Range 1}, 3, false). Sheet 1: giving tree wish list Sheet 2: the adult sign-up list I want for the adult email address (listed in sheet 2) to be looked up and added…
-
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…