Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for March 2016
Discussion List
delete "contacts" in dropdown box
To avoid clutter I want to clean up the contact which I am not using anymore. How I can delete theses "contacts" ?
Feature Request - Dual Windows
OK, so when you're making alot of links to other sheets, it becomes tedious that you have to do the link one at a time - switching back and forth between the sheet and the pop-up of the sheet you're linking to. There are also other times when it's nice to have more than one sheet visible at a time So if it were possible to…
rounding up
Hi All. We are trying to make an order form that calculates a number typed by our clients to a box rate. To do this we have tried dividing the order by the amount per box then rounding up to a full box. we have been advised to try this.add a flat value of 0.5 to anything returned by the above formula. This will force any…
basic math in Web Form
I would like to see the ability to add, subtract, multiply and divide in a Web-form. Asking for financial information and need to add 5 or 6 boxes to have a subtotal. (at least one box is the multiple of 2 other boxes), Then deduct optional box for a final total on Web-Form. Now I ask the person filling out the form to do…
Discussion Prompts
When users of my project plan first started using the discussion feature, it would automatically send them an update that someone left a comment for them. My users are no longer getting these prompts and are now having to email the discussions instead. Is there a way to fix this so that everyone is automatically getting…
Template that automatically sends notifications to assignees on due dates
I'm trying to find an app that automates our processes — finance to training to sales. I want to create a template that I can that I use every time there is a new job to do. When training is booked for example, I want to create a new sheet, add the date of the training and have all the due dates automatically calculate. I…
How would I add an attachment via a Webform?
I am working on a webform that would request actions to help track and manage contracts. Is there a way to add file(s)/attachments to the smartsheet via a Webform?
Measure the performance in terms of time, real vs. plan
Hello, I want to know if I can measure the performance of my team, crossing plan versus real in terms of the total time of the project.
Simple percentage
Hi all, I'm trying to do a basic calcution - creating a percentage of actual revenue against revenue targets. I just need to have a formula that takes our current revenue and shows it as a percentage against target, but I can't for the life of me work how to do it! Any wise words please? thanks Tom
Vacation days formula; how to allow for half-days (or holidays)
Not having a lot of background experience with formulas, I am having difficulty determining whether or not the NETWORKDAYS formula can be "adjusted" to include an allowance for half-days. Using the Vacation template, it calculates the number from start to end days. I have added a check-box column for half-days. If this…