-
Locking Cells/Columns in a Report
Hi Smartsheet - I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being able to edited field, we…
-
CARDS - Add parent title to the card
Is it possible to add the parent title to the card as well? It would make it a lot clearer which item you are working on when the parent is different but the child is the same. For example we have a lot of tasks such as: Design Part 1 Develop Schematics Create BOM Create Layout Drawing Design Part 2 Develop Schematics…
-
Transferring my personal account to a business account
Hello, We are considering a business account at my company, and until now I have had a personal account (that I use for work). With this transfer, we will buy additional licenses for other people in my office. A couple of questions regarding this: - can I transfer my existing account to the new licenses? I don't want to…
-
Starting time with predecessors
Is there a way instead of using a starting date, I can use a starting time? I have tasks to plan during the day for maintenance, this usually doesn't take more than a day. I want to use gantt view as well. I know the hour function has been added recently as I understand, so why can't I add up the hours starting from a…
-
Sheet Sharing
I have a sheet that I "save as new" weekly in one workspace. The workspace has 7 people but the sheet I share weekly has 5 additional people who do not need to be shared to the entire workspace but do need to see that sheet weekly. Any advice on how I can keep these people saved to the sheet without having to add them each…
-
Enhancement Request - Filter Columns
I believe it would be greatly beneficial to be able to filter columns as well as rows. The saved filter profiles was a great enhancement that allows sheets that are used for data tracking to be sorted to data subsets. If you could also save which columns are to be displayed to the filter profile then you could create views…
-
Use API to get Smartsheet Row Id's
Hi In order to intergrate another Application I would like to use the API to request a list of Smartsheet row ID's and selected columns (possibly just 1 column which the the primary key in the other application. This would either be all rows or selected rows. The best output would be as a CSV file eg: mySheetRowIDs.csv ID,…
-
how to create an "interruption" in a schedule?
We are using Smartsheet as a manufacturing/production planning tool. I've created a sheet format that allows us to do exactly that, with tasks for individuals involving dependencies on other parts/processes. For example, a part is routed to engineering for design, the engineering manager for approval, purchasing to order…
-
Trying to Sum Rows of linked cells
I'm new to Smartsheet and struggling with a few things, one in particular is wearing me out. I have several rows of linked cells that pull number values from another Sheet. I'm trying to Sum total these linked cells but the basic Sum formula doesn't seem to recognize these numbers. If I remove the Link the Sum formula…
-
Drop downs issues in form
Trying to build a customer feedback form. No idea why but the form does not save the dropdowns as I have entered them. I enter and save it like this 5 - Very Satisfied 4 - Satisfied 3 - Neutral 2 - Unsatisfied 1 - Very Unsatisfied When I open the form it looks like this 1 - Very Unsatisfied 5 - Very Satisfied 4 - Satisfied…