-
Sharing Sheets with Admins
HI there If i share a sheet with someone and that someone is an Administrator....can he add or remove columns on a sheet? I am seen that he can't. Can somebody give me a good answer on this?
-
Repetitive Task List Instantiation - Editing Multiple Tasks From a Master List
A common experience we encounter is when we have long, identical lists of tasks (7 or more), indented under many parent titles, that need editing, as shown below: PARENT ONE * Task ONE * Task TWO * Task THREE. etc. * PARENT TWO * Task ONE * Task TWO * Task THREE. etc. We have many PARENTS with identical lists of tasks that…
-
Automate RYG Ball based on Checkboxes in Other Columns
I need help from the SmartSheet formula masters... I have 10 checkbox columns (checkbox) and I want the RYG ball to automatically change with the following conditions: * 1) "Red" if no checkboxes are checked. * 2) "Yellow" if some checkboxes are checked. * 3) "Green" if all checkboxes are checked. with one exception... if…
-
Excel Attachments Not Coming Through
Any idea why all .pdfs and "some" .xls sheets come through, but not all .xls that are "Sent as Attachment"? It shouldn't be a size issue. I exported a few sheets to check their size, and they are way under our acceptable attachment sizes. It shouldn't be a permission issue because I tested sending a small .xls to a person…
-
Improved Send Row functionality?
One of the very few things that disappoints me in SS is the Send Row form and function. When I send a row to multiple people, it kind of pretends to send everyone the same email, but in actual fact, each person gets their own email. So I think I'm sending: Email 1 ---> Joe, Sue, Mary But what I'm actually sending is: Email…
-
Values not appearing in linked Excel table
I have a report that pulls from several Smartsheets. When I run the report in Smartsheet, I see all my values appearing. However when I refresh the linked report in Excel, not all the values appear. My values are text/number so there is room for numbers as well as "N/A" -which we manually enter. I have another, very…
-
Authorisation workflow
Hi, I am in the free trial period with SmartSheet and I am trying to work out if I can make it do what my organisation needs. I want to create a workflow to enable my colleagues to create and authorise projects. At the moment we are using word documents and emails. I have a few questions: · I was hoping to move away from…
-
POST request to fill a column with type PICKLIST
I'm using php-curl to add rows to a sheet throught POST requests and it works good to fill all the text fields. But when I try to add data for a column that has PICKLIST as type it won't work. So this is how the column is structured. { "locked" : true, "type" : "PICKLIST", "index" : 5, "title" : "Severity", "lockedForUser"…
-
Emails from Smartsheets
Is there a way to see the emails sent out from Smartsheets?
-
Automatically back dating based upon future date
Hello, I would like to update a sheet by putting a date in one field and having serveral date feild updated based upon the first feild. Now I think that I can do [date] + 15 or [field] + 15 but can't figure out how to set a date and work back 1,2,3, etc weeks from that date. [Field] - 7 day does not appear to work.…
