-
Can sheet EDITOR make sheet "invisible" for a period of time?
I have a sheet for which I'm the owner and I've shared it with 10 people in a workspace. I have one collaborator whose permission level is "Editor -- can share" and I'd like that person to be able to temporarily "check out" or make the sheet invisible to other users while she's making her changes/additions. I know that the…
-
Linking Sheets
I am trying to link two sheets. The main sheet contains all my essential information, however one column has a list of drop down options. If the user selects a certain option from the drop down I want certain information to be presented in a separate sheet. E.g: If in sheet 1, monthly payments are selected from the drop…
-
Sharing Smartsheet
I have a SmartSheet that I would like to share with multiple Vendors. However in the documents are some sensitive data that these vendors should not see. How can I share without having to create a separate documents.
-
Smart Sheet Freelancer Required
Seeking an independent Smart Sheet Consultant to begin work no later that the 31st October 2017 6:00 PM GMT You should be able to screen share and use our already uploaded excel spread sheets to create reports.and sights. You should be able to use the advanced functions of cell linking and formula to create forecasts.…
-
How do I view previously sent e-mails to contacts to verify the e-mail was indeed sent/received?
When we e-mail shared users, there are claims that they never recieved the smartsheet page. How can we verify that it was indeed sent out? Standard e-mails have a SENT folder where you can view such things, but we have yet to figure out if this even has such a feature. ~Angela
-
Locate/Find COUNTIFS
e.g. =COUNTIFS(Recruiter:Recruiter, "Christie", [Deal Date]:[Deal Date], MONTH(@cell) = 10) e.g. = 50 This is an example of how I identify my "deals" for the month in a sheet which lists every deal my company has made. The sheet contains thousands of lines. Is there a way to search/locate/find or highlight these 50 deals?…
-
Cheery picking data from a sales sheet for customer to view
Hello, We maintain orders for customers in a sales sheet, the columns look something like this; Order Number Customer name Description Manufacturer Order Status Ship Date Delivery Date Sales Value This is our master sheet. So to update our customers we have to look at the sheet and email them important information from it.…
-
Here we go!! Ready to roll out our BETA project plan!
After a couple of weeks learning Smartsheets and simplifying our project plan, we are ready to beta test our PM Lite template. https://app.smartsheet.com/b/publish?EQBCT=f5644ec0fe854b2b9c3bf74084bf86d7 It's still pretty rough but with a group not use to a formal PM process it should get us started on the right track.…
-
Export sheet URLs to excel
Hi, I'm trying to export multiple secure sheet links (urls) to excel (or pull them into a report) so I can upload them to a field in Salesforce. Is there any easy way to do this? Thanks for your help!