Filtered Views for External Collaborators
Hello, i am not sure what the best way is to accomplish this. I have a smartsheet that i would like to collaborate with outside vendors. I would like to avoid chopping up the data and giving every vendor their own sheet. I will be adding new data weekly. Update request won't work because they could be getting 20+ lines at…
Error message - publishing SmartSheet calendar to Outlook
I played around with the publishing calendar functionality using ICal and syncing it to my Outlook account. I eventually decided not to use this function and turned it off in SmartSheet. Several times a day I am getting an error message in Outlook related to publishing the calendar. See the attached screenshot. Any ideas…
Linking to a published report from a word document.
I publish a report in calendar view for our staff to view upcoming programs, see their status, notes etc, and one member of our staff uses this for a staff newsletter each week. This link is saved in a word document. Just this week, after the recent roll-out of the UI upgrade, when following the link from the word…
Where did the export feature go for Published views
Prior to the major update that was just made if you had a Read Only Published link the user could download an Excel file of the sheet. Where did this feature go in the new update? We use this to convey a small segment of information to business partners without giving access to our whole data system.
Developing a Matrix Questionnaire
Hello, I am hoping someone can help me design this type of Survey Form to send out to my work employees. I would like to ask them to pick an answer (that I give them), by selecting the radio button. It seems easy enough however, I do not see this. I have attached a screenshot. If you know how to do this, I would really…
Using countifs across sheets to hold metrics for reports
We have a sheet that lists all of our projects (there are over 300 at the moment). We used to keep all of our metrics at the top of the sheet, but every now and again, someone would sort by a value that caused the metrics to get mixed into the project list. So when cross-sheet formulas (vlookup, countifs, etc) became…
ical sync update
Hi, I am trying to sync outlook calendar using ical feature. However, the updates that I am making in smartsheet calendar is not exported correctly. There seems to be bit of delay as ical is exporting old data from my smartsheet calendar. Can you please investigate?
Multi-level dashboards - creating new tab in browser
Hello community people, I have a DB (Dashboard) requirement requirement, and want to get your advice. Usecase - 2 level of DB, Top level: a list of DBs. 2nd level: individual DBs. Non-license users (senior management) go from top level, then click to go 2nd level individual DBs. Requirements - Users are non-licensees. They…
How to publish a dashboard
We recently upgraded our licenses and now have the dashboard/portal functionality. I would like to make a dashboard I've created publicly-viewable, but there is no publish tab at the bottom of my dashboard. I can share the dashboard via "Share", but I need a public audience to have access. Does anyone know how I can…
Share sheet as a copy - Consolidation
Hello everyone, Starting with Smartsheet, I don't find any documentation about distributing a new and unique sheet to collaborators. The idea is : * I build a main spreadsheet, and I want multiple collaborators to fill this sheet individually * I want to keep track of all the status of certain indicators for each…