-
Sheet getting full
Looking for any thoughts on how to handle the situation of a sheet nearing its 500,000 cell capacity. We have a sheet that collects data from multiple team members who submit it via a form. The sheet is for the most part a repository of this submitted data and other sheets, reports and dashboards query the main sheet for…
-
Sheets, Reports, and Dashboards Not Opening in Browser
I’m really frustrated with this issue and disappointed that support asked me to come here instead of solving it directly. Even if I’m on the lowest subscription tier, it’s unacceptable that a problem as basic as not being able to open any sheets, reports, or dashboards is not handled by Smartsheet support. This isn’t an…
-
Edit Intake Form
Hello, During my Intake process I have a number of fields that allow "TBD". After Control Center creates a project I have a need to later address those "TBD" fields. I can go into the sheet and make the changes, but I'd like for the project manager or team manager to be able to make the changes. The data will then cascade…
-
Automatically copy one row when it is the end of the week or end of the month
Hello, I have created an automation to copy a row at the end of a week or at the end of a month so i can keep a log of all the calculated KPI's. This has been working for the past year. Unfortunately it stopped working a month ago for no specific reasons. Does anyone know what could be the reason? Thank you in advance for…
-
Contact List showing as a text only
It happened suddenly. It was working last week. I'm using Index Collect to pull a contact as cross sheet reference. But today, I did not see that working well. Usually it has circle beside my name, suddenly it vanishes, and it just contains text. I'm using those other columns to be sent notification, and it doesn't work…
-
Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
-
Sorting by Time Not Working in Card View
In Smartsheet, there is an issue with the ordering of flight times when using Card View. In Grid View, the flight times appear sorted correctly (e.g., in chronological order). However, when switching to Card View, the cards are not displayed in the same order based on the flight time. This is challenging for our workflow…
-
View Sent Alerts and Reminders in Activity History
Hi Brilliant Folks, I have an alert set-up that was working but suddenly stopped. I reached out to Smartsheet with two questions: * Is it possible to view the history of sent alerts? * Why would an alert just stop working when nothing has changed in set-up, column names, etc.? I was provided this a response: Our Activity…
-
Can I use a sheet to create a purchase order form?
I'd like to create a purchase order form that allows users to select items from a drop-down list and display the quantity and total of each item. I have created a sheet, but all of the items in the primary column do not appear as a dropdown.
-
Surveys and access
What I'm looking to do is use a survey to get end user feedback. This form will be the same for each customer. This information would need to be accessible by my company, the customer and probably the manufacturer as well. They'd only need access to their information; Customer A can't see Customer B and C's feedback and…
