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

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…