As a paid licensed user WITHOUT Admin privileges, is there a way to tell if a Contact listed on a sheet is a licensed user (free or paid) vs someone manually entered? Use case: Automations allow messages to be sent to "Limited" users in the same account or "Unrestricted" any email referenced. However, all contacts visually…
Hi, How do I format my completed tasks to have a checkmark and strikethrough the entire column. Apparently it's pre-set in some templates. But I don't know how to set it up manually. (see below) What do I do?
Is it possible to edit text in a dialog box without affecting all the text? An example would be to bold, strike through or underline parts of the text without affecting the entire sentence or paragraph. Thanks.
hello! I'm new to smart sheet and am creating a dashboard. how do you go about creating a visual towards a goal? would it be a simple bar chart?
Hello, I would like to create a formula where it flags for the following information: Donor Center = other sheet column Donor Center AND Job Title = Ops Admin QAS AND other sheet column Position = Quality Assurance Supervisor Then Donor center = other sheet column Donor Center AND Job Title = Ops Admin Assistant Mgr AND…
The issue involves the usage of the JOIN() formula within SmartSheet, which is resulting in the inclusion of an unwanted apostrophe when the formula's output is copied to another sheet. The JOIN() function is designed to concatenate values, but in this scenario, the copied data is displaying an apostrophe that is not…
Hi everyone, Does anyone know how you can keep someone from completing a line item? I have a sheet where I ask for a resolution to an issue and some users are marking the item as complete without providing the details of the resolution. I would like to block them from the cell until data is entered into the resolution…
I have a dashboard chart widget whose source data is a report on a sheet. There are times when the report accurately returns no data from the sheet that meets the reporting filter criteria. In that case, the dashboard chart widget displays an 'Unable to display chart' error (screenshot below). This error message is…
Hi all, Smartsheet developers review the most voted up community posts to make changes to the platform. I am desperate for them to add target lines to Smartsheet charts. If you’re like me, could you go to the link below and vote up the top two comments…
The typical email notification includes a link to the original spreadsheet row, but my business users will not have access to that sheet, only a limited dynamic view. Is there a way to send a link to that that view?
For the past 3 or so days, in the activity log, when trying to expand the view to see what cells changed, I receive an error message saying we are having trouble reaching Smartsheet right now. Is anyone else having a similar issue or is it just me?
Dear All, I would like some advise if Smartsheet can work offline. Thank you very much.
Help shape the future of Smartsheet. Share your ideas and feature requests.
