-
Project Metadata Sheet (Project Management Office setup)
We are new to smartsheet, using the project management office template set for intake etc. While setting up we have entered our projects into the project intake sheet and the instructions here: https://app.smartsheet.com/b/publish?EQBCT=8c1ace8ce2d14472a986005d454626d8 state to then copy the Project ID into the Metadata…
-
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…
