Enhancement Request: Sheet/Workspace Level References in Formulas

I would like to create notifications for the creation of new sheets in specific workspaces and in general better track what sheets are getting created where. To this point I would like to build a master sheet with drop downs for each workspace showing what folders and sheets are in them. A directory if you will.

This would allow me to build notifications when new sheets are added to workspaces, and have a master smartsheet tracker available to show what my team is working on. Right now our setup is entirely manual, everyone has to go to the project sheet and edit it, and it's just another step everyone has to take when building a sheet, and because of that sometimes the project sheet gets missed when a sheet is created.

Find more posts tagged with

Workspaces

Sheets

Sharing and Collaboration

Formulas

Dashboards

Enhancement Request

Email Notifications

Comments

Shaine Greenwood

Hi Luke,

When you have a moment, please submit an enhancement request using the Product Enhancement Request form to the right of the community site. Your feedback will go straight to our Product team for review.

With that being said, you might consider using our API to create this automation if you have developer resources available at your organization. More information on this is available here: https://smartsheet-platform.github.io/api-docs/

J. Craig Williams

If you have resources and no developer, contact me.

Craig

L_123

I know about the API and am currently working on learning RUBY in order to utilize the API. That said I think it would be good to not have to use the API for this functionality, which is why I suggested it.

I submitted a product enhancement request at the same time I made this post.

L_123

Thanks for the offer, but I don't think we are ready to outsource any of our development at this point. We are still working on building our team of key users and developing internal skills. Maybe once our team gets more comfortable with the program we can start to use the API and hire external developers, in fact I am hoping for that and building my own skills in preparation for that future. The big thing we would want to do is link smartsheet to SAP to reduce the number of times we are inputting information.

Until then I put this suggestion up because I think it would be a very useful tool for users who aren't programmers.

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.