Best Of

dynamic dropdown request is as old as the hills and gets completely ignored by the smartsheet development team.

to my knowledge this is only available through 3rd party app, or through really "machine level" python code which is quite customized.

in my company , some really sharp guys came up with the python solution for their problem. I was not remotely smart enough to port this.

I am using an external 3rd party smartsheet app called DynamicDropDownupdate for Smartsheet, in which you can setup relationships between source sheet columnns becoming target sheet dropdown menues. This works quite well, and I am suing it extensively. The problem is that this is to the best of my understanding a macro that periodically (every minute ?? no idea) checks your source sheet for changes and then applies the changes to the target. SO this requires reloading/refreshing source and target sheets periodically, and it is nowhere near realtime. I guess you could setup up cascading menues, but for sure the update time delay kill the usefulness of using this macro fro this application.

However overall the app is heavensent, without this the dropdown menu update is such a collossal PITA and such an errorprone manual operation that I would have long returned to Excel (where none of this is problem).

Again, this feature would elevate Smartsheet from a pretty website to a really useful tool. Developers, please take note.

@andreadarcy

If you create a helper column, set the name you want in the cell, and the right click and use hyperlink to assign it the URL for your form. Then you can use your workflow to send this cell to the end user as a part of the message and the hyperlink will be active.

It would be nice in the automations to send out a form at a specific time, weekly, monthly etc. to emails so staff can be reminded to send over form responses on a project. Not an update, but fill out a form from scratch.

We are trying to clone a blueprint for another team to use and the fields are not showing up in the same order as in the original, so making sure we configure each correctly is very difficult when there are 70+ individual fields.

Can we please make these sortable?

It would be VERY helpful if we could allow users to change their End Date in a report for a Task. We have 2 Date columns in our project plans. Start Date and End Date. When a user is working off of a Task Report, it would be much simpler if they could change their End Date as to when they completed their task directly within their Task Report and not have to enter the source project plan and change it there instead. Any reason WHY you can change and End Date in a project plan, but not be able to do this within a Report? Please consider this an Enhancement Request.

I'm looking forward to this feature. At present, we separate sheets to cover data over the limit.

Thank you for your response. Unfortunately, the documentation for Table View's expanded cell count includes warnings that, inter alia, Automations and Dynamic View don't work if you go into that space - so no, it won't work. That breaks whole swaths of functionality that we depend on.

I'm going to just roll my own relational database using Power Automate and Smartsheet. I don't like this outcome but it seems like the only option.

Anyone with access to deleting a project, should be able to undelete that project without changing the ownership of that project.

If I accidentally delete another person's project file, and I am tagged as the person who deleted the project file, I must then contact the owner of that project to undelete it, even though I had no trouble deleting the file, and the system knows it was me who deleted it. The act of undeleting a project, in that case, would make me the owner of the project and therefore, it isn't a permissible action. This seems counterintuitive and inconvenient to a person with a project in a folder with multiple users, who could delete items at any time, and not undo it.

i.e: Anything that I can delete, please allow me to undelete that project back to where and who it original belongs to.