Discussion List

  • Is there a way to change info in a master sheet to be reflected in sub sheets?
    In Formulas and Functions
    Hi all! New to Smartsheet so please bear with me and my (maybe perhaps)silly question but one I haven't been able to find a solution to. I am using Smartsheet to compile online student registrations. My format: I have one "Master Shee…
    Answered - Pending Review
    200 6
    Answered - Pending Review 200 views 6 comments Most recent by Andrée Starå Formulas and Functions
  • Email User Completed Form
    In Using Smartsheet
    I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address.  I would like to create workflow automation when a certain trigger has taken pla…
    236 3
    Answered ✓ 236 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Planning Calendar conundrums
    In Using Smartsheet
    Hi, Community! I am wondering if anyone else is using SmartSheet for an institutional planning calendar. I chose a template of project with gantt. Most of the tasks on the calendar, however, are annual, bi-annual, semi-annual, etc. I am tr…
    94 22
    94 views 22 comments Most recent by mitchell.beness113091 Using Smartsheet
  • How are you using Smartsheet to help you homeschool during COVID-19 closures?
    In Staying on the Same Sheet
    We've been celebrating the social distancing brought on by mandatory office closures and work from home has been great! Meaningless meetings have been cancelled. Chatty Kathy hasn't been stopping by our desks with distractions four times p…
    3514 14
    3.5K views 14 comments Most recent by Miaenn Staying on the Same Sheet
  • Dynamic View - new submissions
    In Using Smartsheet
    I am an administrator in Dynamic View and have created a new view. I want my staff to be allowed to submit new items. I have selected that as an option but cannot figure out how to have them actually add a new line. Help!
    75 3
    75 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Smartsheet for Pandemic Readiness- Dont Panic Prepare!
    In Staying on the Same Sheet
    IT departments must take the lead on pandemic response planning... Your Challenge COVID-19 still has a lot of unknowns. Despite efforts by international and regional health authorities, misinformation and misinterpretation of available inf…
    209 0
    209 views 0 comments Started by Thurman Jones Staying on the Same Sheet
  • At Risk Formula Update
    In Formulas and Functions
    Currently using the Onboarding Template Set and in the Sheet Onboarding timeline, I have the Risk flag set, the current formula is to flag if the end date is in the past and the status is not compete (for the row)formula is =IF(AND([End Da…
    184 2
    Answered ✓ 184 views 2 comments Most recent by Andrée Starå Formulas and Functions
  • Smartsheet moving rows
    In Using Smartsheet
    Hello everyone, Bit of a strange one. I have a master list of parent rows each having several children rows. For some reason the order of children rows is changing. I have checked the activity log and no one is editing it and there is no c…
    47 5
    47 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • Percentage increasing by 100
    In Using Smartsheet
    Hi all, I have an issue where, when inputting a percentage into the %Complete column which accompanies the Gantt, it multiplies this percentage by 100! I.e. it turns 1 into 100% and 100 into 10,000% - screwing with the sheet. The strange t…
    Answered - Pending Review
    223 9
    Answered - Pending Review 223 views 9 comments Most recent by Paul Newcome Using Smartsheet