-
How do I "Ungroup" Automated Alerts
I currently have a couple of alerts set up that once the status is marked Complete, to send an alert, based on certain criteria, to specific email addresses. I'm finding that there may be several rows that have a Status of Complete and qualify to send to the same email address, however, it's not sending an individual alert…
-
I shared my sheets from personal account to my business account and now they won't un-link
Hi, I'm hoping someone has done the same thing and can help me figure out what to do :) When I joined my current company, they did not use SmartSheet. I have my own personal Smartsheet account, that is linked to my email address, and I pay for it annually. I have templates and dashboards created and I started creating some…
-
Force people to change a second cell when they update first cell
Hey Everyone, is there a way to force when they update a cell in one column ( in this case Status), they must also update the Assigned To column before they save?
-
How can I combine grid data and Sheet Summary fields into one editable grid sheet?
I have a Sheet Summary Report that pulls data from 48 individual sheets — this includes both the row-level grid data and each sheet’s Sheet Summary fields. I want to have all of this information (both grid and summary data) together in a regular grid sheet, so I can format it, add formulas, and use it in dashboards more…
-
Forms - Ability to Lock fields
First of all, I use Smartsheet Gov, which I know differs (substantially) from Smartsheet Commercial, as I previously worked with that for about 3 years at my previous company. First Question, for forms, is there a way to LOCK a field? We have a field that comes up auto populated with the TDL #, based on the site where the…
-
Sheet/Report Usage
We have create a multitude of sheets and reports and we are wondering if there is a way to get a usage report for the sheets/reports? Without having to go into each one individually and access activity log?
-
Currency format on a Form
I have a sheet with a number column that is formatted as currency. On the form, I have the validation as a number only, but when the form is being filled out, the number does not have the currency format. This is a budget column for large projects and when the amount is in the millions, it is difficult for the person…
-
Error when loading attachments
Hi all, for the last 2 days I am unable to load any attachments. I have restarted my computer. I have cleared my cache and cookies. I have saved the doc to my desktop and tried to upload and drag and drop and nothing works. Please help.
-
Why are the users roles not updating
Ever since the paid users vs. free users rolled out, it has caused my team issues. I have a user that I updated to member, but he still gets the notification that he's a viewer. I then upgraded him to admin and he's getting the same notification. It's extremely important he has editing access. This has caused a slow down…
-
Forms - Ability to Lock fields
First of all, I use Smartsheet Gov, which I know differs (substantially) from Smartsheet Commercial, as I previously worked with that for about 3 years at my previous company. First Question, for forms, is there a way to LOCK a field? We have a field that comes up auto populated with the TDL #, based on the site where the…
