Hi I have two sheets, one acts as a master file for top level view only, the other is a more working doc. On the working doc, I have added a progress column, calculating the percentage of progress of …
I am trying to take a value from the same column & row on a separate sheet and divide it by 160. I tried to go super simple and just do ={Sheet reference}/160 and got invalid. Any ideas on the best wa…
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…
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 {Equipm…
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…
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…
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 sh…
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…
