-
Linking Smart sheet columns to a Resource Management Project Cutoms Fields
I would like the ability to automatically update values in Resource Management custom fields from values in a Smartsheet sheet either a column or in a Summary field. Examples of how this could be used:. In smartsheet I have a portfolio Priority calculation sheet. I would like the priority calculated in the priority column…
-
Program Reports Editable based on Sharing permissions of Source Sheet
Currently if you create a report using a program as the source, only users who have at least viewer access to the source sheet on ALL of the projects created with the Control Center Blueprint can view the report. This creates a problem and misses a huge opportunity. The problem is that this is just the Control Center…
-
Group Sharing Based On Contacts In Sheets
Hello, My Smartsheet relates to a Program and is shared with everyone who is involved with that program. Who is involved is reported in a program information sheet using a contact list column setting with their job title as the column header. It would be nice to notify everyone listed on the program information sheet as…
-
Receive Notification for Broken Dashboards Not Pulling Data
I have 2 thoughts… When a report/sheet name is changed, any dashboards that pull data from that report/sheet also keep that name change so that dashboards do not need to be updated with new file name when changing the corresponding report/sheet name. I would like to receive an email notification if a dashboard breaks so I…
-
Audit Log of Automated Messages / Notifications
We're looking to implement automated notifications via smartsheet to a list of our business partners. Our compliance team would like to be able to keep a log of the recipients to which these notifications are sent, which to my understanding is not available currently.
-
new GRANDPARENT() function
I would greatly appreciate a Grandparent function, especially since PARENT(PARENT()) throws an error. I know we have ANCESTORS(), but that gives you the number of ancestors and I need the specific ancestor value. Ideally, the GRANDPARENT() function would be GRANDPARENT( [reference], [# of generations back] ), that way it…
-
Backing Up Smartsheet FORMS & Restoring a Deleted Form
There needs to be a way to back-up created Forms and allow them to be restored. This has caused a huge disaster when someone on my team just accidently deleted a form last week.
-
Ability to remove all source sheets from a report
I currently have a number of reports, which are having 100+ source sheets of active projects, once a project is complete I need to remove it from the report and respectively add new sheets. However, there's no easy way to remove those completed/cancelled projects from the report today, because I'll need to look at that…
-
Move the Deleted function to another section
Please move the Delete function away from the Edit function for a row in a worksheet. THIS CAUSES A LOT OF ISSUES JUST BY BEING NEAR EACH OTHER!!! Locking rows isn't an option, unless you can tell me if I can lock only certain columns.
-
When using the Workflow for deletions
When using the workflow "Alert someone when a row is deleted," it would be nice if we could have some of the information from that row in the message. For instance, I have an alert setup for deletions, however, it isn't able to capture the Request Title or ID number, because those fields are deleted when a row is deleted.…