-
Project Plan with several Tasks in one Line
Hallo! Currently, we have an Excel sheet, which I would like to transfer in Smartsheet. However I cannot find a way to do so, so hopefully someone can help me. As seen in the picture, every row is an own project and every column (except the first with the name of the project) is a certain day, like a Gantt. So on every…
-
automatically export and then delete rows
We use SmartSheets to collect a large amount of data using a form. We reach the Smartsheet size limits almost weekly. Currently we log in each week, export the data to excel, and then delete rows based on a date criterion. I have looked at Zapier. It looks like I can have it email me the data in excel but the free version…
-
Smartsheet Dashboard Embed Power BI
The new dashboard feature for Smartsheet says we can embed power BI reports by publishing to web, but doing that in Power BI makes your report public to everyone. How can I embed while still mainting privacy as these reports have company information? There is a Power BI option that allows you to embed directly to…
-
Zapier or Automate.io Basecamp Integration
I create all plans in Smartsheet and need the tasks/date/owners to show up in Basecamp to do's or schedule section. I've tried Automate.io and Zapier with no luck. Can anyone provide insights? Thanks!
-
Financial/Accounting needs to expand Smartsheet in our company
I don't work in this realm at my job, but I know that another program (much more costly, I might add!) is being considered to meet our business services group needs. Though not exhaustive, I know they need a program that will allow for processing of purchase orders and needed approvals (electronically), timekeeping for…
-
how to build an interactive dashboard
If I have a dataset looks like below: Project_ID Approval_Status P1 Approved P2 Declined P3 In approving P4 Approved is it possible to create an interactive dashboard showing the approval status of each Project ID? and Project ID put into a drop down frame on the left of the dashboard, user can select any of Project ID in…
-
Pivot Sheet & formulas
HI, I've used pivot sheet to gather required information to show up in a sheet. I've attached a clip of the final result which works great except for the fact that I have formulas in some cells. When a new row is created, the formulas in the cells from above don't copy into the new cells. Can someone help me out. thanks!
-
Auto change a cell based on a checkbox in a different cell (all in the same row though) or change in
I created a pretty intense sheet to keep track on invoices and receipts. I have an "Action" column that is a drop down column. Here are a few of those "Actions" Request Sponsorship Submit Sponsorship Request Invoice Call to pay with CC Call back to pay Submit Check Request Follow-Up Check Approval Mail Check Out Request…
-
PIVOT App
I have purchased the Pivot App. I can get the pivot created, everything works. I create the sheet with the summary Pivot. BUT - when updates are made to the sheet that created the pivot - it is not reflected on the sheet that I added the pivot to. It is like they are no longer connected and active once the pivot data is on…
-
Is there a way to view a map created using Smartsheet labs in the Sight view?
I created a map from one of my sheets and I want to display it on my sight/dashboard but not sure I can do this. I know I could add an image and then edit the interaction to view the map but thought I would ask. Thanks!
