-
Hiding Rows, Columns from Client or User Access
Hello. I've searched and thought but I want to ask the question anyway: Is there some way I haven't found, to hide a row or group of rows (or only show the ones you want) from a user or published view and keep those sent rows in an interactive environment? Heres the situation: Out of my 200 row sheet, I only want to show…
-
Alerts to non-shared resources
We are trying to implement an editorial calendar. Smartsheet works great for this in theory.. ie: we have the primary row as an calculation that shows us: "Client (Content Type) Title (Creator name)" - perfect. this is awesome. We have the due date as the calendar date. - Again.. perfect. HERE IS THE CHALLENGE We have…
-
Formula help...can this be done?
Column A is a date column. Column B tells us if we have scheduled Column A so it will sort into the right report. The formula in Column B needs to state that if Column A is a date, then the value is YES; If Column A says "Not Scheduled" it is No. Otherwise, Column B will remain blank. Can that be done? Blessings, Loann
-
Add requirement to formula is a cell is blank versus not blank
Here is what I am trying to do for our contracts: Cells I'm working with (for the formula) • Contract Start {Date} • Contract End {Date} • Remaining Days {Number} // formula =[Contract End]1 - TODAY() • Contract Status {Dropdown - see below} // formula =IF([Remaining Days]1 < 0, "Expired Contract", IF([Remaining Days]1 >…
-
Email Notifications and Lost Data
No one in our company is receiving email notifications from SmartSheet. This started happening after the upgrade they did over the weekend. We have also lost some data from our sheets. The data was entered and then later disappeared. I've tried emailing SmartSheet about the issue, but have not received and explanation. I'm…
-
Working days and non-working in different countries?
Hi everyone. Does anyone know whether it's possible to attach different rows to different timezones in Smartsheet? This is not specifically for the hours, but more for the days of work. For instance, in the UK we work Monday-Friday but in the middle east the working days are Sunday-Thursday. Therefore, can we assign…
-
Enhancement Request: Batch Updating in App
Hello - It would be great if a user can update multiple columns (status, dates, etc.) by being able select two or more rows and selecting a "batch update" button to update all of the selected rows at once. Currently, user has to select the column to change, then update a particular field, then repeat if multiple fields…
-
Google form → SmartSheet → E-mail Alert
I created a google form that is linked to a smartsheet. (I had to create a google form because smartsheet doesn't have a multicheck option available for the web form capability). I'd like to use the alerts capabilities of SmartSheet so when someone fills out the google form, the answers to go the smartsheet, and it will…
-
Limit View within a Sheet (using Web Forms)
Hello, New to Smartsheet. We would like to utilize a web form to allow customers to place orders/requests whereby the web form would populate the smartsheet for ONLY OUR INTERNAL visibilty/tracking of all requests combined. Currently, when I test this I am brought back into the sheet where I can see ALL requests. Does…
-
Counting Characters for Twitter
Hello! I'm using a sheet to track my social media (Twitter only at this point) posts prior to adding them to Hootsuite. I'm trying to figure out a way to have a column that will incidate wheather or not a text column has too many characters (140) or not. Is this possible?? Thanks, Claire
