Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Feature Request: JOIN argument range
Slightly related to: https://community.smartsheet.com/discussion/release-2016-08-06-formula-argument-declaration-confusion JOIN appears to be "vertically-centric", that is, designed more for joining text from a vertical range instead of a horizontal one. I would like to cherry pick cells from the current row to JOIN into a…
Sights Dashboard Feedback from Power User
Hi there, not sure where to put in my feedback for Sights but I think it's a great tool but has the potential to really be so much more powerful for business users. I feel like I get stopped at ideas due to lack of features. Here are some ideas I hope you can add: - Export to PDF: we use the dashboard as sort of a…
Any way to change the "predecessor"'s values via the API?
I know that such functionality is not supported, but I was wondering if maybe there are work-around. I am creating an script that bulk edits various sheets by starting from one sheet (useful if you want to synchronize multiple sheets) - https://github.com/EffEPi/smartsheet_bulk_edit The problem that I am having is that…
Dates are off by one day (iOS)
Dates have been off by one day for some time now. Anybody got any scoop? App is up to date.
Prevent Check Box formula from erasing when check-box is manually checked by accident.
In below scenario, check box formula disappears when the cell is checked manually by accident. Is there a way to prevent check-box-formula from being erased when the check box is manually checked? • Pls refer to attached picture “Query - Check Box Formula” for check box formula used. Thank you. Jon
List of users and emails
Hi All, Does anybody know of a way to get a list of all email addresses that all sheets have been shared with? We have an enterprise account and can export the list of formally invited users, but this doesn't include a variety of people who shared have been shared with, but who haven't formally joined our account. Any…
Linking cells based on matching criteria
I have two sheets, both sheets have a row of column IDs, I would like to dynamically match the column ID from one sheet to the other sheet and then update a row. Similar to the new Lookup fucntion that was recently released but across two sheets. Has anyone developed a solution for this. My only option is to manually link…
Sheet Notifications
Is there a way to "call out" a person on Smartsheet by tagging them (i.e." @emailaddress") so when we create a comment in a discussion, we can tag someone and they get notified that there is an open discussion or check out a specific line on a sheet? I already know about send request, alerts and reminders. I am referring…
Report is pulling correct results, but cells are blank
I have a set of project sheets that all share the same basic layout and format, AND also have all the same sharing permissions -- specifically, I am the owner of all of them. I'm trying to generate a report that shows me all sheets with an End Date in the future for a specific task / row in the sheet. The report seems to…
Creating a report, Not able to select column that exsists on sheet.
Hello, I use the same sheet frequently and change the title/calendar to fit the need of the project. I also use the same report, and generally just change the sheet the search is restricted to in order to generate calendars for sub contractors for the specific project. However, I'm having a strange error. I'm trying to…
