-
Email User Completed Form
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 place (example a checkbox checked) for the alert to be triggered and email a confirmation…
-
Planning Calendar conundrums
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 trying to figure out the best way to handle that. Would I only be able to do it using…
-
How are you using Smartsheet to help you homeschool during COVID-19 closures?
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 per day. We've been getting a ton of work done without ever changing out of our pjs!…
-
Dynamic View - new submissions
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!
-
Smartsheet for Pandemic Readiness- Dont Panic Prepare!
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 information are complicating the situation as individuals and organizations seek to…
-
At Risk Formula Update
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 Date]9 < TODAY(), NOT(Status9 = "Complete")), 1, 0) but I need to update it because I…
-
Smartsheet moving rows
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 conditional formatting so I have no idea why it is happening. If anyone has any help…
-
Percentage increasing by 100
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 thing is, this is only happening for one of my team. When i do it, in the exact same…
-
How can I remove a sheet reference, so I do not receive the alert ‘Reference a total of 25000 cells
Background: An International source Smartsheet has 1700 rows (and counting) and 85 columns. Using the Index/Match formula, we reference 14 columns of data within a new Regional Smartsheet. Why? Regions want to add additional Country-focused data, data that should not be managed on an International sheet that already has 85…
-
Can the Sys Admin view the overall user activity in Center of Excellence for the assigned account?
As part of the Smartsheet roll out at our company, we 'assigned' our paid license employees several Center of Excellence Training Modules/Courses with different dates to get them completed. I am the Sys Admin and trying to verify who has completed their modules and who has not. Do I as the Sys Admin have access to view all…
