Education
Discussion List
-
Is there a way to change info in a master sheet to be reflected in sub sheets?In Formulas and FunctionsHi 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 views 6 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Email User Completed FormIn Using SmartsheetI 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…
-
Planning Calendar conundrumsIn Using SmartsheetHi, 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…
-
How are you using Smartsheet to help you homeschool during COVID-19 closures?In Staying on the Same SheetWe'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…
-
Dynamic View - new submissionsIn Using SmartsheetI 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!
-
Smartsheet for Pandemic Readiness- Dont Panic Prepare!In Staying on the Same SheetIT 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…
-
At Risk Formula UpdateIn Formulas and FunctionsCurrently 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…
-
Smartsheet moving rowsIn Using SmartsheetHello 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…
-
Percentage increasing by 100In Using SmartsheetHi 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 views 9 comments 0 points Most recent by Paul Newcome Using Smartsheet
