We have an a Smartsheet of Events - tradeshows etc that we will be participating in. While initially developed for internal sharing, I have added a "publish" checkmark column, with those items checked being part of a Report, which I then Publish to our public website. I would like to include a formula in the checkmark…
How do I get SS to send a notification to a contact whose name has just been selected from the list and entered in a webform? Like, when column [supervisor] is set with a particular name, please notify [selected supervisor] of this change.
Is it possible to add more sorting options. right now we only have three drop down bars, I need four. How can I add more?
Hello, I am working on many project and my boss want me to say which task is finish in advance, in time or late compare to the initial date calculated. ex: when the project is finished we want to know which tasks are good and which are wrong. the task drawing start the 2015 01 01 and must be finish the 2015 01 30 if the…
Smartsheet kindly has given us a couple of templates. I am looking for more ! . We are an insurance supplier and our Property Management firms are smaller than the superb case studies here. Of course, the templates can become simple ( but the education and creative is not easy). If I can be so bold as to humbly ask for…
I want to add a field that automatically works out the VAT in a seperate field so i can calculate how much VAT we pay on services. Is this possible? I have tried to add a formula e.g =SUM(amount)*20% and also +=SUM(amount)*0.2 Neither of these work - it just shows an error message.
Does anyone know of a way to edit a radio button list after the inital list is created and added to a web form? We have a product list that we'd like to edit periodically without having to create an entire list each time. Thanks
Hi, has anyone had any luck using an exact match formula is Smartsheet? I have two columns that have text in them. I want the 3rd column to tell me if column 1 and 2 are an exact match or not. I know how to do it in excel =Exact(A1:B1) but not sure how to set up in Smartsheet. Also, can you apply a formula to an entire…
How do I schedule repeating appointments on a specific day of the week; Ex: Every Mon at 10:00 First Tue of the Month at 09:00 I did not see the day of the week variable or formula. Thanks Alan Guggenheim
Is there a way to merge sheets together to show scheduling impacts in calendar view? I'd especially like to keep the coloration of each sheet to quickly identify projects. Anyone know if this can be done and how?