-
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.
-
Merged: Dashboard print to PDF cuts through rows
This discussion has been merged.
-
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
I have two formulas for a helper column to a metrics sheet. I made a column that counts the number of days until an order is due to arrive, and then there are two helper columns. the first needs to take those numbers and return a value based on the number. So if the order is set to arrive in 5 days, then the value would be…
-
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…
-
Dashboard for Existing Project Portfolio Reports
Hello, We have approximately 300 projects built out at the project level with a summary report. We did not implement an intake sheet as this portfolio predates use of Smartsheets. I am trying to build a portfolio dashboard that does not require use of the intake sheet that some of the portfolio templates require. I've…
