-
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…
-
Merged: Insert Attached Image into Cell
This discussion has been merged.
-
Link to Sheet Summary
I have a Master sheet I am trying to pull in data from other sheets on. One of the other sheets I am linking from has several sheet summaries. I need that summary, which has the sums of several columns) on my Master. Is there a way to link to that summary so it is always updating on my Master?
-
Linking cells into other sheets - Latest update only
Is there a way to link a cell from one sheet to another, but only link over the latest change from changed cell?
-
Can I sum two cells together and then clear the contents of one cell without changing new total?
I have two cells that I would like to sum together based on a check box. When Order Received is checked, Quantity Delivered is then sent into my total inventory in row 1. I would then like to clear all of the contents of row 2 through an automation, because that order is complete and done with, without changing my new…
