Best Of
Re: New streamlined creation experience
This "new streamlined functionality" IS THE WORST! Of all the good and helpful things Smartsheets COULD HAVE done (based on thousands of ignored feedback requests) they create this mess instead. Pair this up with their very interesting "permissions" system (Workspace permissions vs sheets permissions) and they have now DOUBLED the amount of monitoring of folders and searching I need to do when someone shares a sheet/report/dashboard. Thanks for making my job harder and not easier! PowerBI is looking better all the time!
LDP
Re: Creating new Sheets in "Sheets" folder
Same here. I just want to browse, create a folder, and create a grid in the new folder. The options aren't there anymore. Hopefully this is a temporary glitch.
vb1
Re: Creating new Sheets in "Sheets" folder
Thanks David - I tried this but the "Save as New" function does not allow you to select the Sheets folder, only workspaces. I also tried drag-and-drop, this works for Workspaces but not for the Sheets folder.
Scott Wadland
Re: Creating new Sheets in "Sheets" folder
Hi Scott, I am having the same experience. I am a daily smartsheet user and am not aware of when this change was made. I make a lot of new content, recently that happened to be in Workspaces, but was under the impression that I should make a sheet at any time. There doesn't seem to be a non-workspace option at all. You can move sheets from workspace to workspace, or from Sheets into a workspace. But standalone Sheets don't appear to be supported.
Yanina Kupava
May Question of the Month - Join the conversation and receive a badge
Hey Community!
Last month we asked about your desk treasures, and it was a joy to read all the stories behind them. There was a bit of everything — a 3D printed dragon, your kid’s sweet notes, more than a few coffee mugs, and fun coworker gifts (like this wooden frog)! I loved seeing you connect while sharing how much meaning these little objects can hold.
Now, let’s switch it up again. Here’s a fun new chance to earn a badge and get to know your peers along the way.
How would you describe your job to a five year old?
I’m really looking forward to seeing what you come up with! Let's see how you break down your job for the little ones.
Share those kid-friendly explanations in the comments below. ⬇️
About Question of the Month:
We kick off each month with a new question. These monthly ice breakers are just one way to help you get to know your Smartsheet peers and rack up some badges and points in the process.
Everyone who participates by answering the question prior to the end of the month will automatically receive a unique participant badge once the question closes at the end of the month.
In addition to the participant badge, the top three answers based on Community member votes will receive the Top Answer badge. To vote on an answer click on the upvote icon associated with an answer in the comments below. Multiple votes allowed and encouraged!
Rebeca S.
Re: Pivot App is not recognizing the Contact Columns
Hi Thomas, Thank you for the response but unfortunately as it is our main tracker and we have more than 10 contact columns and all were need to calculate summaries via pivot table.
We have entering the contacts manually with in the sheets itself and all were valid contacts. (We are not importing from outside).
After multiple testing I see error getting only when,
- Contact column activated multiple Contacts for a cell and
- Pivot Table build from a report (It is working fine when pivot is built directly into sheet)
These pivots we were built 3 years ago, it was working fine until last week and suddenly now Contact column values were not recognizing for Multi Select and Pivot built from a report.
A fix to the issue from the smartsheet would be a great help.
#PivotError, #MultiSelectContact, #PivotfromReport
Re: Fill-down formula, while preserving formatting
Yes this can be done! To fill down a formula and formatting, single left click in the cell containing the formula and format, hold shift, and single left click on the last row you want to fill to. Next, press CTRL + D to fill down the formula and formatting.
Travis
Workspaces takes up a section of my screen
Hi Smartsheet,
Workspaces takes up a section of my screen and I'm not able to scroll all the way wide right when the Workspace panel is open. Please allow me to continue scrolling to view all my sheets's columns.
Thanks,
Eric
Eric B.
Re: Adding a dashboard link to a different dashboard
Having the same issue. I reached out to support yesterday and told me their engineering team is working on a resolution. Have no idea on an ETA… hopefully soon
kdelgiorno
Re: Has anyone used SmartBackup?
Hi @Laura Bell,
when it comes to fully functional backups (including formulas, formatting, workflows etc.) to my knowledge there are only 2 solutions available:
- the mentioned SmartBackup: https://www.smartsheet.com/marketplace/apps/smartbackup-smartsheet which is officially available in the Smartsheet marketplace.
- and SmarterBackup (part of a collection of tools) sold by Smarter Business Processes: https://smarterbusinessprocesses.com/smartercontrols4smartsheet-backups/
2 of my customers in Germany use SmarterBackup (to get fully functional backups) in addition to scheduled backups by Smartsheet.
I can recommend both solutions, but both suffer from some limitations of the Smartsheet API. Namely automations cannot be deactivated (but can be removed) for the backup copy and it's not possible to backup more than 100 items at once.
Again, not the fault of the solution providers but a limitation of the API they both use.
Hope this helps
Stefan
Stefan