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.
Discussion List
Count if formulas with system created dates
Hi Everybody, We use webforms for my team to log in calls to our Hotline. Due to popular demand I recently changed from having the call date entered on the form to the system created date. Now I can no longer use my handy formula to keep tabs on how the call are going each day. I used to have a formula for each staff…
Feature Suggestions
I would like to make two small suggestions. When you are using "days" it would be helpful if it specified whether they are business days or calendar days. For example, when you are using days in the duration field of a gant chart they are business days. When you are using them to set a reminder they are calendar days. It…
Formula - contidional "past due" based on %Complete and Finish date
list of tasks. I want to calculate the past due date for tasks that have not completed. I have variations of =IF(NOT([% Complete]1 = 100), (TODAY()-Finish1), "do nothing") where it is not working it is the do nothing - it is currently calculating values for items that are complete.
Community Examples
There are a lot of communtiy examples that are generated and published. They are hard to find afterwards. Could there be a sandbox built that holds all these? Many of these aren't as fleshed out as a template, but have one or two usefule formulas that solve a particular problem. Thanks, Brett
collaborators and users
I am new to smartsheet. what are the primary differences between collaborators and a users?
Cool Way to Display Milestones?
Does anyone know of a cool way to display project milestones (only) that would look great in a presentation? Is there a template out there perhaps?
Scrolling
My smartsheet keeps scrolling up on its own. Why? How do i stop this?
Is it possible to duplicate columns in Web Forms?
I need to collect data that I need to duplicate 10-15 times. Is it possible to use web forms to collect the information and have it move to seperate rows as the customer fills in on one web form? Is there an efficient way to do this without creating 30-40 extra columns?
Holidays incorporated into schedule
hi does anyone know how to put a holiday into the schedule so when you are creating schedules it will automatically account/not account for those days? i know it can be done i just can't remember how. thanks
Looking for some suggestions or Ideas
We have been using Smartsheet for a few months now and want to enhance what we do. We run our customer projects on Smartsheet (all working fine). We would like to create a Change Control Web Form, however we want to pick up the Customer Name from one place, the project from another and the CCF details would be manually…
