-
Issue with Cell Linking from Metadata to a new sheet in the same workspace
I have an existing workspace for a project. I used the PMO template to create all my workspaces. I added a new sheet w/in the project's workspace and want to link the Project Name from the Metadata to this new Onboarding worksheet. The link shows up but the name does not appear. I've saved, exited, refreshed, etc. but…
-
Vlookup
what is the best way to look up between smartsheets and keep the data fresh =VLOOKUP([Equipment ID]@row, {Equipment Tracker H5 RM 8.8.24}, 1, false) Equipment ID]@row = equipment id this sheet {Equipment Tracker H5 RM 8.8.24} = large data block in another sheet this works but will not refresh if data changes help
-
Index match returns a wrong value
Anyone able to help with an Index/match formula that returns a wrong value? We've a formula that is returning a wrong value. I believe the formula is correct (it's the same way I write it in .xls). We are referencing another Smartsheet in the formula. I understand if I was getting an error (#invalid value, #No match), but…
-
Cells Reverting back to Previous value
Hello I am trying to change cell values and for some reason they keep reverting back to the previous value. Before: After: I click save and then refresh and then they highlight blue and change back to the previous data Activity log is registering it and says that i change it back when I dont I even tried to enter in new…
-
Linking Sheets together in a compiled/ master sheet with real time updates
Hello, I'd like to propose an idea to help innovate smartsheets already spectacular features even more. One feature that I do not see is essentially combining / stacking sheets as a compiled master sheet. The compiled sheet should reflect updates made from each individual sheet. There does exist an automation where one can…
-
Merged: Please allow access to create formulas from reports
This discussion has been merged.
-
Merged: Report Referencing
This discussion has been merged.
-
Data Shuttle / Cell Links
Hey all - I am uploading a report from our ATS program from a google sheet using data shuttle to put it into a smartsheet form. I added check boxes into the smartsheet form for the responsible parties to mark off which stage they have completed from the report. Since I don't want to lose the data, I am adding new rows for…
-
Merged: Bi-Directional Cell Links
This discussion has been merged.
-
Linking data by Primary Column
We track data for customer accounts in a couple of different categories. This inevitably means that some customers (not all) appear in both data sets. We spend some time ensuring that the data entered is consistent across both, but this is a manual check. It'd be good to be able to 'link' data between sheets conditional on…