-
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…
-
How add more project on multi-project template
I have create a workspace using multi-project construction template - I only two proejcts. I want add more project simailar to project 1 and project 2, but want to make sure they are part of the roll up and also dashboard
-
Looking to add differentiators? How can I do that without using RAND
I am looking for a solution that woul d create a unique identifier for my row. I am using a index match formula to pull through needed fields, however the items that I am matching often have the same names on the reference sheet. I cannot adjust the names, but I would like to build a column that is unique to each row.