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
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…
I would like the ability to lock not an entire column or row, but just a single cell, and then unlock it when data is added to another cell. The solution could be implemented as a workflow.
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…
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…
This discussion has been merged.
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…
When managing references in a sheet, the menu that pops up to begin editing/duplicating/deleting cross-sheet references is incredibly hard to work with. The box that pops up does not allow the user to expand the bounds of the menu - vertically, horizontally, or diagonally. Ideally, building the menu out with functionality…
I wish there was a way to have bidirectional cell links, where the destination sheet picks whichever field was updated last. I have included a few posts I found (the latest dating back to 2020) requesting this enhancement.