-
How to populate a column in a sheet based on a column from another?
Beginner here. I want to populate a column with the names of people in a new sheet, with the data to be taken from a column in an existing sheet. In this sheet, the names are given in the column multiple times over since it reflects each of the accounts these people have. I'd like each individual name to only be included…
-
Looking for most recent date
I have two sheets. The first is a tracker for up coming reoccurring tasks and the second is a copy of rows that have been completed. In the first sheet I would like to collect the date from the "date" column in the second sheet if the "Combined" column values match that on the first sheet and if "Most Recent" is checked in…
-
Control Center optional template issue
Hi All, We are using Control Center for our projects, we use it with 4 different countries and every country has it own set of templates that they can select when creating a project. So in total we have 16 optional templates that are unrequired and unselected. The country then selects their own 4 templates. And creates the…
-
Separate numerical and text values of differing lengths from a single cell into separate columns
How do I separate numerical and text values of differing lengths from a single cell into separate columns? For example, I'm trying to total the "AREA" Column, but due to having "SF" in the cell, it will not return a numerical value. The numerical values to the left are of differing lengths, making this problematic. The…
-
Populating a Dropdown List
Hi, is it possible to populate the contents of a dropdown list from another smartsheet?
-
Is there a way to allow users to email comments without viewing the smartsheet?
Hi, Is there a way to allow users to email comments without viewing the smartsheet? Is it possible to modify the email that gets sent when you @someone@something.com from the automation@app.smartsheet.com, remove the reply in smartsheet box so they just reply to the email? When you add them as a commenter they can view the…
-
How do you move a row from one month group to another?
I am using a 12-month calendar template. I have content in one row for May, but need to move it to June. I know I can copy and past but this leaves behind the comments, files, and proofs. I have tried sorting in various ways and it does not seem to work. Do I have to change the formula? Or is there some kind of a way where…
-
How to create an Index Match Formula for multiple sheets?
Hi, I am currently trying to create an Index Match function which will be able to search multiple sheets (5 to 6 separate sheets) for the correct information. The destination sheet has two columns that it will look at. A "TIDC" column where staff members place a ticket code An "Assigned to" column, which is a contact list…
-
Index Match Across Multiple Sheets
Hi Everyone, Hoping y'all can help as I'm at a complete loss. I'm trying to pull information into 1 master sheet based on a unique identifier across multiple sheets and it's just not working. I can get it to work for 1 sheet using =INDEX({Status},MATCH([Proj ID]@Row,{Proj ID},0)). Each sheet is for a different team,…
-
How can I use VLOOKUP to find data from multiple sheets and combine it in another sheet?
I have an existing database of suppliers/vendors set up in a sheet, and I'd like to automatically show if they're currently working on a project and which project they're currently working on, as well as the dates they're working on the project within that sheet. I'm creating a supplier sheet per project which shows all…