-
how do i import multiple large googlesheets, with multiple worksheets, and then integrate them?
Hi, I have inherited several google worksheets. each worksheet is stand alone, with about 20+ workbooks per sheet. the first several workbooks of each sheet are basically summary dashboards of the remaining workbooks. so there's lots of vlookups, sumifs and so forth. When I try to import, of course only the first sheet of…
-
Export a PDF of a Dashboard
When I export a PDF of a dashboard which contains reports, I lose the formatting of those reports. Is there a way I can export a pdf that includes the formatting from the reports. More specifically: I have highlighted rows on my report. I then bring the report into a dashboard that I wish to export. When I export the…
-
Copy , move or share selected cells / information with others
Hi All How to copy/move or to share rows to another sheet with column of my choice . or to share some cells / columns of my choices with others but not all row information The reason is i donot want to share some information with others Im doing it with trick like to send to landing sheet with some automated actions to…
-
Single request for update with Multiple Tasks
I can send out a single request for update for every task that is assigned to the person(s), however, these person(s) are working on multiple tasks at the same time. I need a daily update of their progress. So, each person may be recieving 20 or 25 seperate requests each day. That's just not doable. Is there a way to send…
-
Mass Change/replace approvers in workspaces
Hello, We are using Smartsheet for budget forms and approvals. I have at least 30 workspaces and serveral budget forms and approval set up within each workspace. Is there a way to mass change or replace an approver in all workspaces? Thank you, Christine Burns Osceola County Sheriff's Office
-
Form row count alert
I created a form for people to sign up for a class. I have 8 sessions available for the same class but with different dates and times. The maximum amount of attendees we can have per session is 150, so the sheet will end up having 1200 rows if all the sessions get full. I want to try and get an alert for when each…
-
Card View settings
Hi I am unable to amend the Card view options settings on my request tracker sheet. I have tried going to settings and ticking the options I want added, but these are not appearing in the Options list. The sheet I am using is amended from the Customer request tracker sheet supplied for a Smartsheet tutorial. Please can I…
-
Date baseline VS. Date Actual
Hello Team, I had just started working with smartsheet fairly recently and still getting the hang of it. So I am working on a project (well you can call it a program) that has the following: Deployment of multiple sites with multiple devices (which we call "nodes") per site Each site (or node) has the same tasks performed:…
-
User access issues
Dear all, I'm having a strange user problem and I'm not sure if anyone else has run into it or knows what's up. I'm trying to collaborate with a "free user" colleague on a shared sheet - she needs to be able to generate pdf documents per row. In the access testing phase I tried the process with two other users as follows:…
-
Grouping info on reports
Hi all, I have 3 spreadsheets for which i want to report information from. All of them have common information/references (i.e. POW1234) but the name of the columns where that information is will be different from spreadsheet to spreadsheet. Is there a way to, on reports compile or group all the rows that have the same…
