-
Renaming columns affects reports
Why is it that changing the name of a column in a sheet breaks all the reports that include that column? I need to go into each and remove the column with the now defunct name and then add the column back into the report again. This is tedious and frustrating (what if I miss a report?). Fortunately conditional formatting…
-
Form URL Link
Hello everyone. My issue here is that I have created a form and I am not sure how to shard it with other users as there is no URL Link for the form, only available for the spreadsheet. On the Manage Forms, I can only see the button, "Test This Form". Any ideas? Thank you in advance!
-
Sight Template
Hey, do you guys have a template for Sight? I see that there are many for sheets but none for Sight, and the bank Sight listed as a template only redirects to an empty Sight. Would really appreciate a templace as I don't see how to modifty the width and height of the objects I'm trying to import onto Sight. Best.
-
Profile Settings Mysteriously Changed?
How do I change my settings to stop overwriting cell content and default back to 'insert'? I used to be able to just type over something, but now the contents are overwritten. For example if I have "There is 90% in this." in a cell and I want to update it to 95%, it will now write over the '90% in this." completely instead…
-
Question re: image attachments when using Smartsheet for Outlook Add-in
I use the add-in and whenever i am moving an email to Smartsheet, it automatically selects all images in addition to any PDF or other attachment. My signature line contains 6 images and so every time i add something through the add-in, it tries to pull these same 6 images. I must de-select them each time. So here's the…
-
Shift license and owned sheet at same time to new user
I have 6 licenses and 6 licensee's and want to transfer a license to a new person from a current person and transfer the owned sheets to the new person. Problem is that the license needs to exist with the new person to give the sheets to that person, but i can't give them the license until i move the owned sheets. I hate…
-
Default form date to Today + constant
I am creating a form that un licensed users will use to submit requests. I want the default for the form to be Today + 4 business days. Is this possible? It looks like the default date can either be hard coded to a specific date, or set to Today. Any help would be appreciated!
-
Flagging duplicate registration plates
Hi, this is my first post on the forum. I use smartsheets for work but I have created this account to use the forums. I am attempting to create a formula that will allow me to use conditional formatting when two entries use the same registration plate number. The sheet is set out like this (im unsure if the link at the…
-
Locking a Form from further editing after a specific date
Hello, We create forms for volunteer events. We are running into the issue where people are signing up until the very last minute. Is there a way add a deadline to the form or lock it? Or disable the form link. Thank you
-
Forumla HELP! Check boxes then counting £ values in columns
Hello community This is my first post, struggling to achieve a formula command. can you help? I have several columns, one being a check box column named "Payment" When one or more of the rows is checked within this "Payment" column, I then need the system to calculate the £value across three other columns, names "30 days"…
