Best Of
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
Re: Are New Folders No Longer Allowed In Sheets Directory
@Genevieve P. I am curious why this was not rolled out like any other big change? Why was it hidden in the Community Forum? As a System Admin on a large account, I like to be the one to provide information on changes as big as this in a constructive manner. I try to be proactive so I don't get hundreds of questions. It seems really strange to me how this change is being handled by Smartsheet. Thank you for the detail above, has Smartsheet created an information page about this in one place?
Rebecca_Kolker
Re: Can you create a workflow to copy a row to between sheets in different Workspaces?
Hi @Tony Fronza
I tested and found that creating copy-to-another-sheet in another workspace is possible.
The workflow does not show the sheet in another workspace as candidates at the first time.
The workaround that worked for me is to copy rows manually first. You can use the normal sheet and workspace directory in the manual "Copy to Another Sheet" dialog panel. Then, when you go back to the workflow, you can search the sheet, and it will pop up as candidates.😀
Re: Sharing reports with data without even view access to the source sheet
@johngraham78 , if the user only has view access, then they can't view the hidden columns. IMO that's a good feature. I've provided view access to clients and hidden columns that I didn't want them to see. However, you need to be aware that if they download the sheet, the hidden columns will be downloaded and will be accessible.
Crown