-
How can I connect multiple sheets into 1 master sheet?
I have multiple sheets, each populated by their own form. I would like each sheet's columns imported into the master sheet and populate the same row. Is that possible?
-
Automatic refresh after another person makes change in sheet?
Hello all, It seems that a sheet will automatically refresh after a fixed period of time, assuming you have no unsaved changes, when someone else has made a change to the same sheet. It'll give you a pop-up message and then display the refresh icon next to the sheet title. Does this happen after a specific period of time?…
-
One Smartsheet with Multiple Tabs
Does Smartsheet support having multiple tabs within the same sheet? If so, how and what is the best way to set up?
-
Merged: date format option
This discussion has been merged.
-
Auto-Number Not Working
I have an Auto-Number function running in one column and after number 1966, I added information in the next row, and it spit out the number 1997. I then deleted the information in the row and then added it again and now its 1998. I added another row after and its 1999. I need the next row to be 1967. Any suggestions…
-
Upload Thousands of Excel Documents to Rows
I have been building a workspace for inspection tracking. Before this we were utilizing an Excel doc that would use a macro to create a new Excel doc for each inspection with the information that was entered. There are 2332 excel documents. The information in each doc are not in individual columns. The filenames are Asset#…
-
Copy row with no hierarchy on one sheet and make it a child on another.
I have a been working on building a asset inspection tracking workspace. I currently have 4 sheets built for it. The first, Asset Master List, has all of the assets and information about the asset built into it. This sheet was built from an Excel Import. The second sheet, Inspection Form, has all of the form responses for…
-
Shouldn't predecessors and dependencies work differently?
This is not just with Smartsheet, but any project planning software I've seen so far. Dependencies have four types, and this is how they work: Finish-to-Start (FS): The "normal" type of dependency. This sets the start date equal to the day after the finish date of the predecessor. You can adjust the duration or finish…
-
Dynamic Dropdowns
I've been able to create and update 1500 dropdowns within seconds. I know a big issue in this community is wishing their is some way to update dropdown selections, with a small tweak to my javascript, options array may not contain null elements. FIX: const options = rows.map(x => x.cells.length && x.cells[0].displayValue)…
-
Auto Add/Subtract to Inventory
I am attempting to create an inventory sheet for my business and was wondering if there is a function to automatically add and subtract to a number in a cell. Maybe something similar to say a button that +1 or -1 when clicked. If this is not available what would be the best way for my staff and I to updated inventory…