-
General Ledger - Payments Tracking incl Budget Compare
Has anyone done a SS that incorporates a "form" of invoice entry (web part?), that after entering automatically logs to a SS tab, then can track budget vs. actual cost (and allow projections) for a project......MS Excel has a good template but without additional programming it only does one calendar year of…
-
How to find out how many columns am I using in a sheet/report
Good morning, I looked through and didn't see this question, so if it is posted elsewhere, my apologies. Is there a way to know how many columns you have on a sheet without having to manually count them? I know I have a few sheets with anywhere from 25-50+ columns, but I've not found a way to get a count automatically. Not…
-
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, ~…