-
Approver From a Form
Hi All, I'm new to Smartsheet, so apologies if this has already been asked and answered. I'm creating a form, in which many different users will be filling out. They will fill out their Supervisor's name, and email address. I would love to find a way for the form to be sent to the manager for "Approval" and submission. I'm…
-
Construction Contract Work Flow/Best Practices
I work for a construction firm and would like some guidance in the first steps to creating a "contract health" dashboard. I am managing all contract packages and the documents that supplement them for all of the projects within the company i work for and would like to find consistency and a more "automated" checks and…
-
Chart Problem
Hello, I'm trying to create a chart that shows the percentages of people who have completed a training module and their respective division heads. I have a sheet with a column with "yes" or "no" for identifying completion and another column with the division heads. When I create the widget and add the chart, I'm unable to…
-
How to find Items in Sheet that are not in dropdown list?
We have a column that has a dropdown list. I have it selected where what is entered has to be in the dropdown list but have admins can override the entry. This is ok because I don't want them to be slowed down when adding a new entry. However, I would like to go back after the fact to find entries that are not in the drop…
-
Choosing Column for Baseline
I have a sheet that has three existing date fields. I want to create a baseline on two of the fields. When I set up a baseline it uses the wrong field for completion baseline. I can't seem to figure out how to change what columns it uses.
-
Smartsheet Row Limitation of 20K
Is anyone aware if Smartsheet going to increase the cap of 20K rows? It would be great if we can get at least 100K at minimum.
-
Import with Data Shuttle but keep some columns
I import an excel attachment into a sheet on a monthly basis using Data Shuttle. The report contains data for the last 13 months, example May 2021 to May 2022. The next month when I import the report again, it will contain June 2021 to June 2022 and again the month thereafter will be July 2021 to July 2022. I would like to…
-
Need help with formula disappearing in status column.
I am working on building a template that has a column for Task, Done, Status, Assigned To, Velocity, Start Date, End Date. The status column is a drop down with the options of To Do, Doing, Review, Implement, Done, and of course uncategorized. The Velocity is a drop down that has a series of numbers based on Fibonacci…
-
Multiple proofs per row?
Is it possible to have multiple proofs active per row? I am working on a contract submission process, and we have multiple attachments as part of the contract; I would like to be able to be dynamically editing multiple documents as proofs at once. So far I am getting the error that I cannot convert multiple non-image…
-
Gantt chart without specific start date, as for a proposal
Is it possible to not have a specific start date in a Gantt chart, and have all other tasks stated as days/weeks/months from this nonspecific date? I'm assembling a proposal, and don't know the start date, but do know the relative duration of all subsequent tasks and WBS elements. I would like to express only the durations…