Best Of
Re: Alert someone when a row is deleted
Happy to help!
Yes, that would be ideal, and maybe that is something that could be developed.
Please submit an Enhancement Request when you have a moment
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!
Andrée Starå
Re: Are New Folders No Longer Allowed In Sheets Directory
@melissalk You can house multiple assets in a single workspace and just share the assets individually. Just because something is in a workspace doesnlt mean that you have to share the entire workspace to someone.
Paul Newcome
Re: Duplicate a sheet from the workspace left navigation bar
@Lekshmi Unnithan this is an awesome and useful release, but until the formatting, formulas, https links, sheet links, etc.. are also included in that duplication, this wont be 100% useful. However, it may be useful for those who want a similar structure and same data but with a clean slate for visability, but for me, i prefer to have everything duplicated and dump what i dont need (faster than re-adding everything back in).
😀👏Thank you for this new "LIVE DRAFT"
(DRAFT = Until everything mentioned in this Note below 👇 is added & working 😀)
Note:This initial release only duplicates sheet data. Customization options such as including or excluding attachments, comments, cell links, and other elements are not yet available but will be introduced in future updates.)
Julie Becker
Re: Blank rows added to bottom of sheet / form
Is there any update for this? These same 10 rows are in our project intake sheet and our summary sheets and is throwing off our metrics/formulas for some of our dashboards.
Kam114
Re: Is there a way to ONLY display the Gantt chart in my dashboard widget?
I would like to add a related point to this thread. I am not aware of a way to display a gantt on a dashboard including the relationship between tasks and subtasks. This task/subtask view is available within the project plan sheet but not in the project plan report which must be created to source a dashboard. This would be a nice feature to consider for future enhancement.
Andrew Goldberg
Export Column Properties
I would like to be able to export the column properties of a sheet. It would be incredibly beneficial to be able to export the extensive structure:
- Column Name
- Column Type
- Allow multiple values per cell
- Restrict to list values only
- Values
- Restrict to dates only
- Allow multiples contacts per cell
- Restrict to list values only
- Add contacts
- Restrict to checkbox use only
- Style
- . . .
You get the idea.
I am aware that you can export the current data that exists within a sheet; but I am looking for the sheet setup.
Thanks!
Chris Walker
Resource Manager Reports - date logic capability expansion
Resource Manager Reports need date logic capabilities beyond the standard last week, last month. Flexible logic like "today()- 2 months", or "today() + 6 months" etc. Having to update an existing report and or the resulting data and formulas each month so it displays the information that is needed rather than just enabling the logic to have a rolling date report waste a lot of user time.
T. Yano
Re: Latest Comment column disconnected, still not able to create new or recreate
This is a bug Smartsheet needs to fix.
Charles Osborn
Re: Inconsistently updating Latest Comment Column
Experiencing this on my own smartsheet, not a template.
First time of use I had to refresh to get latest comment to show. After that refresh, when I add another comment to test the "latest" update, no amount of refreshing has worked to show the newer comment.
Little disappointed as this feature would have solved our issue of the "Comments/notes" column being swamped with old comments we don't need to see anymore. Oh well.
NT801
Re: Set filter to only show certain columns
@Debi.Fisher Correct, you can't add rows from a report. Only in a sheet or a form connected to that sheet.
Possible workarounds (the key to all Smartsheet solutions)
- Use Dynamic View if you have it. This can limit column visibility and allow users to add rows
- Embed the report on a dashboard with a form, this makes it easier for users to navigate between the 2
- Add a column in the sheet with a link to the form, that way users can click on that link from any row to create a new one
- Have users install the SSFeatures browser extension and save their own views of the sheet with the specific columns hidden/unhidden that they need.
Darren Mullen