-
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…
-
Sheet Name links not taking user to correct sheet row
Hi there, since yesterday I have noticed that the Sheet Name column links in reports are not taking the user the correct row in the source sheet, as they have always done. There does not seem to be a pattern, sometimes it takes the report user to the top of the source sheet, or to a random row, or the odd time to the…
-
Combining data from 3 different columns to create a summary report
Hi all. I am trying to create a summary repot that combines 3 columns that I have on an Intake Sheet and Archive sheet. The data that is in each of these columns are pretty much the same, but we have them separated out based upon on the different clients that we have. Within these 3 columns, it has Job type data (i.e.…
-
Text Wrapping on Report Group Headings
It would be very helpful to have text wrapping on the headings that appear when you 'group by' on reports. In our case, we group some reports by project name as this is most intuitive for the users of the reports. These project names can often be several words long, and it looks really untidy when half the project name…