-
Property Management templates
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…
-
Can you add a VAT field in a smartsheet?
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.
-
Editing Radio Buttons
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
-
exact match formula in Smartsheet
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…
-
Day of the week formulas
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 into one calendar view?
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?
-
Multiple start/end dates (sub dates)
Hi there - I am making a media calendar using a basic project template. In one my media channels (eg: radio campaign), I will be on air for a total of 6 months, however only the days Monday, Tuesday, Wednesday of each week. A repeating event or ability for 'sub' start/end dates would be awesome for SmartSheet, so that the…
-
Managing Deadlines for Marketing Department
Our marketing department handles the event marketing and promotions for a company that puts on 14 road races. Each race's deadlines over lap with the other race's deadlines. Is there a way to see all the tasks from multiple sheets on one sheet but sorted in order of deadline?
