-
Consolidating names in a Columns
We use Smartsheet to manage several projects, with multiple and repeat customers. We need to create a report that reviews (2) columns (distributor and customer) from serveral sheets. We would like the end report to combine the (2) columns from all of the sheets and remove any duplicate names from each column. I have gotten…
-
Advanced Cell Linking Capabilities?
When we list our monthly marketing promotions (what's new, what's on sale, what's exclusive) in our Marketing Master Plan, we link those cells to other sheets where it would be useful to have that data on hand (for copywriting, graphics design, email plan, etc). Only problem is that if something gets added at last minute…
-
Is it possible to apply conditional formatting to reports?
My current understanding of reports is that each row replicates the formatting from whatever sheet it pulls from. Is it possible to create conditional formatting rules within the report itself?
-
Export contacts to Mail Chimp or Google
Can someone guide me to export my Smart Sheet contacts to mail chimp for a campaign? Thank you. Ben
-
Auto Date updating a published report of Events List
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 to send a notification to a selected recipient
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.
-
More A-Z Sort options.
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?
-
statistics on multi projetcs
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…
-
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.