-
Reports and Dashboards Backup
I would like to be able to set up recurring backups for reports and dashboards just like we are able to do so for Sheets in a workspace.
-
Create copy of Smartsheet data, scheduled and automated to be used as trendlines
I have created a PowerBI dashboard using smartsheets as the data source. Live updates are working perfectly, and updating data is running smoothly. I have been asked to show a trend line, and progress with these metrics. How can I build a table (or Smartsheet) using snapshot data in an automated workflow using smartsheet?
-
Line breaks for widget titles
As far as I can see, there's no way to add a line break for title widgets, or other widgets (like reports or charts). When there is a particularly long title, my team has to manually adjust the size of the widget box. It would be nice for formatting purposes to hit Alt + Enter to create a line break for titles :) It has…
-
Merged: Ability to Add Line Breaks to Titles & Widgets
This discussion has been merged.
-
Calculating sum of Receipt Totals from another sheet based on criteria of 3 columns
Hello, I am trying to build a metrics sheet to put into my new dashboard. This workspace includes receipts/ invoices that have been submitted by employees. On the Metrics sheet, I have the following columns- Branch, Field Cost Center, Charge Account, Auto Code, Total (YTD). I am trying to pull the receipt totals from…
-
Is there a way to create a central dashboard that collects the separate forms for multiple teams?
I am building a new Intake System and I need multiple teams requests forms all to funnel to a central location without using one giant form. I need any help, suggestions, ideas? Our business will have about 10 forms for our department. HELP!
-
Dashboard
I have a dashboard roll-up sheet that is using a COUNTIF =COUNTIFS({sheetname}, [Column2]10) formula to count the number of cases an employee has. I know the employee has cases on the sheet, but the field shows zero, instead of the number of cases that are assigned to them.
-
Sharing Portal to Unlicensed Users
My company has a Smartsheet account that I am a licensed user under. I have created a portal that I would like to share with our non-licensed suppliers. The information is sensitive, so I selected the share option of "only available to users shared to this item". I added all the Supplier POCs to the shared list as viewers.…
-
How to get a formula to count only negatives or only positives
There was an error rendering this rich post.
-
Formula to Count Ages of Orders
I'm trying to create a formula that counts the open orders based on the date the order was created. The thing complicating the formula is that it's for a metrics dashboard, so I need it to count the orders that are between 1-3 months old, 3-6 months old, 6-9 months old, 9-12 months old and over a year. I'm at a complete…