-
Gantt Presentation
We run our project delivery sheets in Smartsheet and are required to present them to clients on a monthly basis so they can see status updates and timelines. When we print to PDF, it reduces everything on A3 to tiny print and the client has to increase the view to see what is written. One of our clients uses another…
-
Admins need indicator showing users were previously Provisional Members
Need an indicator on the Manage Seats and Seat Type Report which would show that the user was previously a Provisional Member and therefore can not be provisional again. The current report, manage seats and share only will show that a user is a Viewer - which then begs the question of can this user become a Provisional…
-
The "Master Program View" (Dynamic Sheet Aggregation)
Problem: Current Limitations Reports are "Flat" Lists: Current Reports can aggregate rows from multiple sheets, but they function as static lists. They cannot perform project logic (dependencies, duration calculations) across those sheets. No Cross-Sheet Critical Path: There is no native way to identify a "Critical Path"…
-
Adding YTD totals without using Sheet Summary fields
I have a sheet the tracks manufacturing operations. Each year, I need to summarize YTD totals from the sheet. This is resulting in many sheet summary fields each year. As time goes on, I will run out of the limit of 200 fields. Is there a way to automate any of this, either with automation or having information go to…
-
How do you create a dynamic list of unique values from multiple sheets?
I am trying to create a "level of effort" calculation where we compare the count of bidded, lost, and awarded projects against a specific criteria, which is often a dropdown column in the source sheet. I have tried using JOIN, COLLECT, and INDEX from at least a dozen posts in the Community but nothing has worked to date.…
-
Copy Automation from one Sheet to Another
Is it possible to copy an automation from one sheet to another?
-
All 24 workflows became invalid today
I was the original owner of this sheet with 24 automations which have been working for months. I went on leave of absence for 6 weeks and ownership was transferred to someone else who doesn't know smartsheet. I came back a week ago and everything was still fine. Suddenly today I got 24 emails (and so did the owner) for…
-
Please enhance Column Contacts and Form Contacts by allowing Groups to be used!
I could go on about it, but there are some basic “table-stakes” sorts of features that need to be incorporated into how column contact lists are handled within Smartsheet. First and foremost, please, for the 37th time, allow us to drag a group in and create items contacts within a column contact list. ALSO, please make it…
-
Automation Request: move rows to the bottom of the same sheet
Please allow smartsheets to move a row to the bottom of the page when you click the check mark. Like a todo list. When you click the check mark it moves the row to the bottom of the list and the incomplete items are left at the top of the list.
-
Unable To Create Project Using Control Center
Hello community! This is my first time trying to use Control Center so bear with me. I've been tasked with creating a solution within Control Center to provision new projects. I have my project sheet, I have my intake. I created a program and blueprint on the Control Center side. It references the intake sheet and a…