Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Archived 2015 Posts
Archives for July 2015
Discussion List
copy rows with formula's
When I copy a row from one sheet to another sheet; all the formula's in the cells are replaced with values in the target sheet. So my formulas are gone in the new row that appears to the target sheet. Is there a way to have the formulas copy over in the row so they are intact in the target sheet?
Locked rows
Can someone with editors access request updates, attach files, start discussions and set alerts on locked rows?
Autoupdate Formulas based on user entry
Hello! this is my first post and I would appreciate help. I want to setup a cell (call it "Cell1") on a row that is empty until a different cell ("Cell2") is clicked with a checkmark; upon Cell2 receiving the checkmark, I want Cell1 to autoupdate with the present date. Is that possible? thanks!! CVM
Sharing between workspaces
I have a master data sheet linked to several reports. I would like to share a workspace containing just the reports, and make the 'master data sheet' not visible to the collaborators. How can I do this?
Production/Manufacturing/Importing
Hi we do alot of importing of containers and production/manufcaturing jobs is there a smartsheet that we could use to have all container imports in one place? what would the best template be to use? It would be easy to use one sheet for each but we really want to have it all in one place if possible?
Automatically create multiple rows in a smartsheet
I'm creating a couple of web forms with a single smartsheet. Each one will capture slightly different details. The forms are sort of like a helpdesk queue, where the users can have different requests, but ultimately all the work goes to the one helpdesk team, and the work is all 'queued' into the smartsheet, and from…
Is there a way to create multiple columns on a web form?
I would like to create a web form, but do not want it all listed vertically. Is there a way to create a form in landscape with multiple columns?
Trailing Commas Break Predecessor Logic
Before the new Predecessor column type was created in the Critical Path update, Smartsheet would automatically truncate extra commas or spaces in the Predecessor column. Smartsheet no longer does this, and it not only "looks" bad, but if the column isn't cleaned of these extra characters, the Predecessor functionality for…
Is there a way to hide a completed row (% Completion Column) in a project?
Using a project smart sheet with Gantt functionality, I would like to be able to hide competed tasks in the project sheet. It is used for production scheduling so the once a task is completed it is not needed to be viewed again unless desired. Note... predecessors are used so deletion of the task is not desirable.
Initial Setup Assistance: Hierarchy Req- Multiple Clients, Multi Projects, Multi Tasks
Before I get to it and go crazy generating all my works, can you please offer assistance in the best way to set up SS for my needs. Essentially, I want to be looking at one project at a time...my trials have left me with multiple tabs across various projects and clients, it gets confusing. If you are familiar with OneNote,…