-
Can you use Groups in Contact list column type?
We have different groups created under user management, for example, email team, marketing team etc. I wanted to know if they can be used inside a column with contact list column type for a project? If yes, how? If not, what exactly is the use of creating these groups apart from workspace, sheet sharing?
-
Automate sheet creation
Can I use automation to trigger the creation of a new sheet? Here's the situation. I have a form that adds a new row to a sheet. I would like to evaluate the primary key's value against what already exists in sheet and do one of two things: if the value already exists add the row to the existing sheet for that primary…
-
Auto-check checkbox upon import?
Hi, I have a Smartsheet sheet that is fed by Formstack submissions. I added a checkbox to a column - how do I auto-check that checkbox on all imported rows? Some background: this sheet feeds into a report along with several other sheets. All the rows on this sheet are from one district, and I want to note on the report…
-
Convert Report Filter to Sheet Summary Formula
I have a number of reports with sophisticated filters that use an important master sheet as the source. I'd like to have the ability to create a formula from a report that I can paste into the master sheet's Sheet Summary section in a COUNTIF or SUMIF format. This function could be in the File menu under Save Filter As...…
-
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…
