-
Problems sharing a published dashboard
I have created dashboard that I wish to distribute (via published link) as "anyone who has the link can see the dashboard". Said dashboard has 8 chart widgets that pull data from reports. Chart widgets viewer mode are set as "their own perspective". When opening the dashboard using the web link, users get the following…
-
If you change a column name; it doesn't automatically update in reports?
For example, I had a typo in a column name, and I fixed it, but when you go to reports, it is not reflected there? Do I have to delete that column and add the new column because I changed the spelling? Surely, there is a way that it automatically updates the reports?
-
iframe will not scroll on ipad?
Hi, when I embed the iframe of a sheet in a website, on an ipad, you can't scroll the sheet right - left or up - down. Anyone else had the issue and know how to fix it? Thank you
-
Sheet limits and column formulas
Hi all, Sheet limits suggest 100,000 cross sheet referenced cells Does a column formula (referencing a single cell on another sheet) count as a single cross reference or is it multiplied by the number of rows on the inbound sheet? Also, are these limits strictly sheet limits, or will the limitations cascade to other…
-
Cell Limit Issue
I have the above sheet which as approx. 277,000 cells. I attempted to set up an automation from another sheet to add missing work orders to this one and it says: please help
-
Get Month and Year and Group/Sort
I've got a sheet in which sales reps input their daily activity. This sheet has a date column that is required. I'm trying to make a dashboard to track month to month levels of activity. Perhaps I'm missing something but there doesn't seem an obvious way to do this. I've tried making a report to group by month and sorts…
-
Help with creating a smartsheet dashboard!
Hi, I created this report showing all of the delayed tasks and tasks for the current week and upcoming week. I want to have a 3 summary charts (most likely a pie chart) with a breakdown by status, a breakdown by workstream, and a breakdown by assigned to. As the report is right now, I can't create a chart because there are…
-
Import of Excel File
@Paul Newcome Hi Paul hope you don't mind me tagging you into this. the attached file with the tab called "live recording" is the file i am trying to import into Smartsheet's. the issues I am having ( a big issue ) once I import this file into timesheets all my formulas are #UNPARSEABLE. I am really struggling to…
-
Sharing A Sheet Outside of Network
Good Afternoon, I am trying to share a sheet with someone outside of my network (A project manager at another company). I am giving her "Viewer" permissions so she can check in on our projects. When I go to sent the share email, I get a popup that says another person owns her email account and it asks if I want to proceed…
-
Limit to number of cards in card view for Kanban board use
Hi, I would like to use the card view of my spreadsheet as a simple Kanban board, but I need to set a limit for the amount of cards that each column can contain (or at least get notified when a set threshold is crossed). For example, if the Kanban board is designed to show my projects sorted by their status (like "not…
