-
Health and Wellness Solution
Good afternoon everyone. I am building a Health and Wellness Solution on my personal account to keep track of my health by logging things like; water intake, exercise (including type of work out, est calories burned, etc.), food intake, sleep tracking, weight log etc. Has anyone else done something similar using…
-
Holidays for Project Schedules when using Control Center
To give a little background…. We use Control Center and our project managers are primarily set up as Editors, as the Admin permissions are more than is needed. We have a handful of Admins. The issue: Since our project managers span the globe, holidays are numerous and various. We don't want to add global holidays to the…
-
Rich Text formatting in cells
I would love to see rich text formatting be available in cells on a sheet. We have several reports where we rely on certain words in a cell to be a different color than the other words in a cell (quickly showing variable options or redlining changed content if only a word or two has been altered). Currently, we are only…
-
Cannot Move Smartsheets b/w Workspaces
Greetings! Seeking support for an odd issue. I uploaded a Microsoft Spreadsheet into Smartsheet, creating a new Smartsheet. It was saved in a workspace that I own. I am attempting to move that Smartsheet to another workspace that also shows me as the owner. But in doing so, I receive the attached error. I have a valid…
-
Using report information in a new sheet
I am working on creating a streamlined way to obtain information from our 66 non-profit groups in order to request specific credentials based on what zone their group will be working in. I only need full name and email addresses from the group leads. All other information needed, I and operations managers would enter. I…
-
Data Mesh: Mapping incoming data to an existing hierarchy in target sheet
Hi all — I have a target sheet that has an existing year/quarter/month hierarchy: I plan to use Data Mesh to bring data from a report into this target sheet. This data will be updated fairly regularly throughout the year. I've set Data Mesh to copy and add data, based on a unique ID. Is there a way to make sure incoming…
-
New Formula Error message #ERROR IN RANGE
Right now the Smartsheet formulas will pass through errors that exist in ranges referenced in formulas. This can result in error messages like "#INVALID DATA TYPE" in formulas where that is fundamentally impossible - making trouble shooting much more difficult. If, instead of opting for passing through any existing error…
-
Silent Data Loss in Dynamic View for Unlicensed Users (4,000-Character Limit)
I’m raising a serious usability concern with Smartsheet’s 4,000-character limit, particularly when data is entered through Dynamic View by unlicensed users who have no visibility into that limit. In this case, an unlicensed user entered detailed meeting notes directly into Dynamic View. Once the limit was exceeded, the…
-
Introducing Query Streams - Automatic Database to Smartsheet Sync
Hi Smartsheet Community!We're Query Streams, and we built a tool to automatically keep your Smartsheet updated with data from your databases and APIs. What it does: Connect your database or API to Smartsheet and set a schedule. Your sheets stay updated automatically - no more manual exports or copy-pasting. New records get…
-
WORKAROUND FOR AUTOMATION EMAIL TO RECEIVE SEPARATELY AND NOT BUNDLED IN ONE E
Hi anyone here have a work around or formula in my case i created a project where in Effectivity date reach it sends email notifications i also created a helper column for subject to have a unique fields and not bundled in one email but in this case if the same effectivity date different details it was placed in one email…