-
Roadmapping with data living in SmartSheet
Hi all - Currently some functional areas of my organization are doing roadmaps similar to the image attached for their leadership. There's a desire to have the data for these roadmaps live in SmartSheet and push towards report automation. They really like the condensed view with multiple items in a lane (vs rows on rows on…
-
Report for Non-Aggregated Days
Our contracting companies submit invoices monthly, and the invoice dates reflect the actual calendar dates worked. However, in Resource Management (RM) and Advanced Reporting, time data is aggregated by week. When I filter for January 1–January 31, the system returns data based on the week-ending date. As a result,…
-
Smartsheet Setting
In Smartsheet, we can publish a sheet with an open link for anyone to edit. However, this same setting for publishing a report with an open link for anyone to edit is disabled at our enterprise level. Do you know if there is a reasoning for this feature to be disabled for reports but not sheets? Thank you in advance for…
-
System Admin: How to export a list of all Smartsheet assets across the account?
Hi everyone, I am trying to generate a report that lists all assets (Sheets, Dashboards, and Reports) created by users within the same Enterprise account. I have System Admin permissions, and so far I have tried the following: Navigated to Admin Center → User Roles and Reports → Generate reports Selected Sheet Access to…
-
Not showing the result after submitting entry to the form
Any one also experiencing issue in Smartsheet right now. Where in after submitting entry on a created form in Smartsheet, it did not show up on the sheet where it supposed to show up. However there was a confirmation email that entry was successfully submitted.
-
UPDATE - Health and Wellness Solution
Here is what I have built out so far for my Health and Wellness Solution. Please note some information has been redacted, including my Forms Dashboard which is where I go to log most of my entries, it is more for me to see, it's not as pretty as these are. I'm a dork and record many things just for the fun of it. I started…
-
Admin Center has been Buggy
Hello All, While Smartsheet continues to be a critical tool for our teams, the issues we’ve encountered in the Admin Center are beginning to impact efficiency and confidence. Some of the recurring areas we’ve raised include: User Stability: Users who we delete seem to randomly come back into our user lists. Has this…
-
How do I avoid the cross sheet cell reference limit of 100,000?
I have several formulas that are critical to one of my dashboards. They reference a master sheet that grows daily in number of rows. I end up getting the cross sheet cell reference limit warning about every 15 days. Is there some way to easily mitigate this? I'd like to avoid reducing the size of the master sheet so…
-
Merging Rows from Duplicate Speakers
I have a sheet that I am using to collect COI from faculty, but our faculty often are involved in multiple activities that often leads to them inputting several COI entries. I've managed to create a duplicate checker to see which faculty members have entered their COI twice, but that doesn't necessarily solve my issue of…