-
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
-
Automation to Send Notification to Shared Mailbox
I am trying to send a notification to a shared mailbox, when a row is added (from a form), with certain criteria within one of the fields on the row. Ideally this row would contain the information from the submission (similar to what is sent when submitter selects 'Send me a copy of my responses'). If this is possible,…
-
How to maintain formula generated data when a line moves to another sheet
I have a sheet that is arranged with parent/child lines to track new recruits for positions within the company. The parent line is the position name and the child lines are the individual recruits being considered. When we're done hiring, we'd like to keep some recruit's info for future hiring, but in another sheet. I set…
-
How do External Users return when re-shared and previously downgraded to Guest
Recent updates of USM articles state "Once downgraded to Viewer (or Guest), they can only be upgraded to Member manually by a System Admin." They also mention if a user is removed/access revoked, they can be re-shared using the same email. We have a policy that ALL external provisional members are downgraded to Guests at…
-
Unable to open a support case with AI Bot
I am trying to open up a support case but it seems like all inquiries now have to be directed to the AI Chatbot first. I've done this twice, having the AI chatbot create a case for me. However, I don't see my case in the support portal at all, nor have I received any type of email confirmation telling me a case has been…
-
Sum last n rows
Does anyone know how to write a formula that will sum up the last four rows only? Example- The GPO Volume dollar amount gets populated each quarter. I would like a formula that would remove row 11 and add in row 15 once the value is in there so I can only show the last 4 quarters total volume. Thanks in advance!
-
SUMIF cell values land within a given week
Hey, I've gotten some fair formula experience over the last year (mostly through googling and this searching this forum) but hit a brick wall with my latest ambition… I have a smartsheet in Gantt mode tracking events and sizes relating to the event. I'd like to be able to use a date picker in the summary tab to pick a…
-
Bulk Update Premium App Permissions Issue
Trying to use the 'Bulk Update Premium App Permission' feature. We received the template, updated it and on the upload we get the below error message: ''To upload this list, make sure everyone in your file has a correctly typed email address' However we never changed any of the email addresses, simply amended True/False on…
-
Change color for contact list?
Is there a way to change the color of the circle with the contact's initial? We have someone on the team with strong preference for a color... Thank you!
-
Smartsheet Regions Australia, now generally available!
June, 30, 2025 Smartsheet Regions Australia instance is now generally available. Smartsheet Regions provides control over where your data is hosted, making it easier for you to address your organization's regional privacy and governance requirements such as the Australian Privacy Act and EU General Data Protection…