-
Government Utility Projects and Asset Records
Hello Smartsheet Community, I work for the City of Minneapolis, in Minnesota, and I’m looking to reach out to see who is working for governments (local, county, state, or federal) while incorporating Smartsheet into their utility project management processes. Smartsheet is restricted from its privacy policy to release any…
-
Slack notifications with more context.
Hi, I have just set up my sheet to send slack notifications whenever the status of a task is changed. So for example I have two columns, one is for tasks and the other is status (of the tasks). So an example would be: "World domination" I "In Progress" Now say I conqure planet earth and want to move on to building my evil…
-
BUG?! - Inconsistent Date Format (US/UK)
I have a regular gantt sheet with start date / end date, which shows up in UK format on the sheet as per my personal settings. However, when I link to that cell from a metadata sheet that I am using for dashboards the date shows up in US format! I have another date format column which is for baseline start and baseline end…
-
Scanning a Barcode
Does anyone currently know if smartsheet is capable of capturing data from a bar code?
-
Counting cards according to their status
Hi. I have four projects, each assigned to a unit division. Each project has tasks in different implementation stages. By default, Smartsheet counts how many tasks are in each stage (column). I want to use that counting to display in a dashboard, so I can see the status of tasks implementation by unit division in a single…
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
-
Disclaimer
My office creates schedules for our customers which are intended to provide an overall estimate of time involved to ; but not a guarantee. We would like to include a conspicuous disclaimer or splash screen in some way to ensure that the intent is abundantly clear and the schedule is not mis-used. I have placed notes in…
-
Notificatons no longer working
I have been successfully using the same smartsheet as a tracking system for almost a year. Recently I have realized that no one is receiving their notifications for one particular notification rule. It is not specific to one user not receiving notices, so there must be something wrong with the rule. But I have looked it…
-
Read Confirmation?
I've set up a SmartSheet for information sharing in my agency. The sheet is updated daily by those with Editor permissions. Is there any way to get a "read confirmation"? In other words, is there a way to tell if each member of the organization viewed the sheet? Thanks
-
Hidden Column Data Viewable in Export
Hello, I have a table where I hid Column C that has confidential information. Viewers and Editors cannot Unhide the columns of Confidential Information. This is amazing. However, here's the kicker... If the viewer/editor Exports the smartsheet they can unhide the hidden columns. How can I stop that to keep these…
