-
View access only to a "set of rows" ?
Hi, When I share a Smartsheet, Is it possible to give view access only to a "set of rows" ? I have a sheet with hundreds of rows. But I want to select/define the rows collaborators can view and edit. Is it possible now? Thanks -George
-
Master Sheets
Hi, I am trying to find a way to link my master sheet to new project sheets. My Master sheet already exists and lists all our premises, product in them and also locations of product. All we rollout new products - this all needs to be ammended in the master sheet. Is there a simple way to link this master sheet to any new…
-
Automatically populate a "STATUS" column with 1 of 5 values
I am looking to automatically populate a "STATUS" column with 1 of 5 values based on critera/conditions are outlined below. The key drivers here are the - [% Complete] - [Start] Date - [F/C Finish] Date - this is a column I have set up that uses a formula to predict a Forecast Finish ([F/C Finish] = (Today() + (R x D))…
-
Search functionality on attachment contents?
We are wanting to move our documents from SharePoint to Smartsheet. However, one small benefit of SharePoint is that a search done will return results of those keywords if they are in the body of the document, not just the title (excluding PDF's). Is this a function that will be made available in the near future for…
-
HOW CAN I VIEW ONLY LINES WITH RECENT CHANGES
I WOULD LIKE TO 'FILTER' TO VIEW ONLY LINES WITH RECENT CHANGES .NOW I NEED TO USE YELLOW HIGHLIGHT TOOL AND SCROLL IN THE LARGE DOCUMENT WHICH TAKES TIME TO DO.IS THERE A QUICK WAY JUST TO SEE THE LINES THAT CAHNGESD AND THEIR PARENT WITHOUT USING THE REPORTS?
-
How can I tell how much data a sheet is using?
We have a particular sheet in which we're attaching short audio clips. However, I know that audio can eat up space rather quickly, so I'm wanting to know how much space that particular sheet is using. I've clicked on the properties, but don't see a data total within that area. Blessings, Loann
-
Editing User Name
I'm trying to get all of my contacts organized and there is one in the User Management Group that is greyed out, thus it won't allow me to edit how their name appears (it's in all lower case - OCD!!!). Help? Loann
-
Cross-project Date Dependencies
Hi, The Help page on Cell Linking says ( in the first paragraph ) that it's possible to do 'cross-project date dependencies.' Sounds like just what I need! But I can't figure out how. Does anyone know? I have several project with gantt sheets and I'd like to see how project dates are working together, or not. Thanks, ~…
-
Convert Project Sheet with Start/End Dates to Weekly Summary Showing Items Starting/Ending/In Progre
Hi - is there a way to convert a project sheet with items that have Start/End dates listed, into a week by week summary report that shows the status of each of those items in a particular week? In any week, I'd like to see which items are Starting (based on Start Date), Ending (based on End Date), and In Progress (assuming…
-
Recurring Reminders
Team, Is there any way to set up recurring reminders on individual tasks? Thanks you!