-
Export and Import
How do I Export a Smartsheet to edit and add items and then Import it back into Smartsheet without creating a new Smartsheet?
-
Expensive Smartsheet!
We are a small company and we need use of just ONE sheet to be able to send to customers for them to be able select drop-downs (and a little bit of free-type) to create a bespoke item. Looking into the pricing etc on Smartsheet it is going to cost us £684 per year!! Is there any other way that we can do this slightly…
-
Multiple users editing a sheet at the same time
I noticed that Smartsheet allows 2 (and maybe more) people to open a sheet in EDIT mode at the same time. It looses the changes made by one of them based on who hits the SAVE button first. Is there is an option which doesn't allow a sheet to be open in EDIT mode if someone else has already opened it in EDIT mode? Thanks.
-
How to make a User Group a Dropdown List
We have created user groups for different departments and have several forms with a column of users. How do we make the drop-down on the sheet pull from a specific user group? Right now we have to manually add/remove names from each sheets' drop down list which defeats the purpose of building user groups.
-
Allowing Circular Reference
I would like to run a calculation with a circular reference =IF(Date1 = [1]1, 100 - Total1, [1]3). This allows me to keep the cell as is if the IF statement is false. Is this possible? [1]3 is the circular reference.
-
Holding a calculation until specified date.
Hello, I would like to set up a row of cells to run a calculation at a specified date and time. If that is not tricky enough, I want that calculation to remain as is thereafter even though the data that the calculation uses would change frequently. Is there a way to prevent a cell from running a calculation until a…
-
Changing Colors of Gant Charts
Is it possible to change the colors of the main timeline bars (not just sub-timelines) on a Project sheet in Gantt view? I do not like the grey.
-
Row or Record roll up and multiple forms or sheets
I have been attempting set up a relational database for multiple client use. This database should track records (rows including child rows) as it progresses through different phases. Projects may stop periodically and should be searchable and may be re-started later. I have tried using 3 column relational connection to…
-
Auto move column info
I'll try to explain the best I can. I have a customer who will view only a summary sheet in Smartsheet. This info is pulling from various cells in individual Smartsheet store pages that they cannot see. This summary is set up in a "One store per Column" arrangement. As the store page info is populated, various info…
-
Unique numbers in a column
I have a sheet that we add rows to everyday. One peice of data that is added with every new row is a case number (unique identifier to show us who we are working on). How can I get a total of unique case numbers? I simply want a count of all case numbers no duplicates. So if case 12345 is on my sheet 5 times I only wanted…
