-
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…
-
Count multiple criteria in a row
I have spent hours scrolling through all the great advice in the Community, and there is not a formula that is working for me. I need to count all the Semi-Annual Update, In Progress, and Waiting on County in a column. =COUNTIF([Status Report]:[Status Report], "Semi-Annual Update") works great to count all of the…
-
Formula help - due dates falling on weekends
I've got formulas in my sheet that calculate due dates that fall on weekends, and I've used conditional formatting to highlight those dates to alert me to those dates that are on Saturdays and Sundays. Now, I want to move those dates to the Monday next. Is there a way to automate that? Ultimately, I need the best way to…
