-
Auto Date on Forms
Does anyone know how to have a template form automatically use the current date? I have a form I use for collecting data and it has a start date, due date, etc. I would like it to automatically use the current date as soon as the Smartsheet is generated from the template. Is that even possible? TIA
-
Need Help with Formula, want all project summary sheet to record most recent step completed
Hi I have a summary sheet that contains all projects that my various PM are working on, the project summary sheet looks like this: Each project then has its own sheet for the PMs to keep track of what steps have been completed for the project, looks like this: On the summary sheet in the "most recent step completed" column…
-
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…