Best Of
Re: Question about Formula
You would probably need a helper column to pull in the inventory value, but this column could be hidden. Then use conditional formatting for the highlights.
For the second question, that is a probably. Without more information, it is hard to say exactly. My usual way of cheating the system is instead of using the linking, I start out by typing in the formula =Index( Then I use the reference another sheet and select that cell. Back in that formula, I then remove the Index( leaving just the = and the reference. This can then be made into a column formula.
Is there a way to create a template from a full workspace?
I am working on creating a workspace for onboarding new employees. Essentially it is an interactive checklist that will remind people of upcoming tasks etc… I have my main sheet, and then I have other sheets that I use for referencing different data and pull it to the main sheet. I would like to make this whole workspace a template so that every time a new employee starts, managers can grab the template, fill in a few names and everything else populates.
I tried to "Save as New" and this didn't really work as sometimes it seemed that data would update in the "New" workspace, but then other times my data would be sent back, or pulled from, or combined with data from my original sheet.
I tried to "Save as Template" but that simply saves my main sheet and not the rest of the workspace.
Thanks,
Re: Table view initial release is now generally available for all customers!
Table's search functionality is something we have all long desired - kudos. One question: Is there a plan on the roadmap to bring table views to reports as well?
Enhancement Request – Adding recurring backup events to event reporting
We would like to request an enhancement to the event reporting functionality that enables visibility into the execution status of recurring backups—specifically, whether they are running as scheduled over time.
Currently, Smartsheet’s event reporting allows us to see when recurring backups are initially scheduled. However, it does not provide visibility into whether those backups are actually running on a weekly basis as intended. This gap makes it difficult to verify if users are following our recommended backup practices.
Resource Management - Date Range end of Contract
The time frame should include a pre-existing option for "through end of project" (specifically for utilization)
Lauren Y
Re: Document Builder Mapping Transfer
@Joe Goetschel Wow, 900 projects, that's a lot! By using the API, you can create a structure where the documents are created in a database and then returned to the specific project, all within Smartsheet API. :)
Guilherme Jaquer
Re: Retain Document Mapping
KempenUSA, I'm in the same boat with not being able to save/re-use the document mapping. My mapping takes over an hour, so I can't even engage with this right now. I keep up-voting the enhancement request!
By the way, you explained your situation so clearly. I could picture every action. I started reading it and then I had to look at the author again to see if it was me! : )
Re: Automation emails and text
Hi,
I hope you're well and safe!
This is incorrect. There is no EMAIL function in Smartsheet.
You must check the answers from the AI.
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD
✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏
Andrée Starå
Workspace Nicknames
The ability to provide nicknames to workspaces and the ability to group workspaces, so it's easily identifiable to you but doesn't change the name for the others (ie: owner). I have so many workspaces share with me and it's hard to remember which is which.