-
Adding Names from Sheet 1 to Sheet 2 with Counter update and handling duplicates
Good afternoon, I'm trying to achieve the following without success: I have Sheet 1 that as forms are submitted a Names column is filled. I have Sheet 2 with a Names and Counter columns When a new submission occurs, I would like to get that name from Sheet 1 and add it to the Name column in Sheet 2 if it doesn't exist…
-
Is it possible to Update Cells in Both Sheets when they are Linked?
What we are trying to do is use one sheet as a general project breakdown (Sheet 1). Within that project breakdown is a construction schedule. We want to make a second sheet that contains all the information in the Construction schedule section of sheet 1 and turn that into its own sheet (sheet 2). I know this is possible…
-
How do I add age range
I am trying to take a list of all employees that includes their info like department, name, and age and then create a age range (like 16-24, 25-34, etc...) so I can then count how many employees fall under each age range. I have tried two ways and neither work. FIRST ATTEMPT: -The first and i think easiest is to have a…
-
How can I use a function to pull dates from Sheet A to Sheet B?
I have a master sheet of dates for multiple programs and projects. The layout of the sheet is: Program | Project | Start Date | End Date Each program is divided into hierarchies as such: Program A --Program A-1 ----Program A-1 | Project A | Start Date | End Date ----Program A-1 | Project B | Start Date | End Date…
-
Auto populate data in Forms
I am trying to auto populate the data in Forms for example if we select ID the corresponding fields will get auto populated with required values. As per the attachment if we enter any ID in the CUS ID field it should populate the PSS First Name, Last Name, email and Manager email. I tried to do this by cross sheet Vlookup…
-
Unique Information in Smartsheet Form
Hello! I am working on a survey in Smartsheet that will request updated/missing contact information from our customers. In some of the questions, we would like to show the customer what we have on file and then have them update if needed. Is there a way to pipe this information into the survey that would be unique for each…
-
Update linked cells in Smartsheet Calendar App
It seems like any cells that are linked out cannot be updated from the Calendar App. I want to confirm that this is my issue before I give up. We are using the calendar app to view a roadmap of projects provisioned by Control Center (which is why there is cell linking). Any workaround for this would be greatly appreciated.
-
VLOOKUP issue
I am trying to pull totals from my 2023 sheet into my 2024 sheet. The totals I am pulling are in a different column but same row as where I want them, so I decided to use VLOOKUP. 2023 Sheet: 2024 Sheet: I want 'Total 2023' to be pulled and placed in 'Previous Years Total' for each corresponding row. My formula:…
-
Grid help needed to reference different POs with changing totals?
Greetings- I created a SS for my finance dept. Basic form where they can select a vendor from a drop down menu and enter that month's bill with what they paid. Each vendor has a different PO number with a different total amount on that particular PO (purchase order). Im having trouble figuring out how to start with a PO…
-
Cells Updated in Original Sheet and not updating in outbound cells
I have a master date sheet that I update dates for projects when they change. These cells that contain dates gets linked to project sheets and should be updated when they are changed. For some reason, the updates are not happening. The cells themselves still say linked. I have tried unlinking them and relinking to no…
