-
Enhancement Request: Auto-Refresh Functionality
I would like to request the addition of an auto-refresh feature within Smartsheet. I use one worksheet most of the day and I have to manually refresh the worklist several times each hour. It would be great if the auto-refresh feature could trigger anytime someone performed a change but I would settle for an auto-refresh…
-
Meeting agendas for Local government
Hello, I am wondering if anyone has used the Meeting Management template to create a Council meeting agenda? If so would you mind sharing how that works for you. Thanks, Jaquisha
-
Blocking already selected dates in Smartsheet Forms
Hi All, I have a smartsheet form setup to allow users to book events. I have added a calendar option in there to allow them to choose the date. I would like to block/grey-out the dates which have already been chosen. Currently I see no option when editing the Form which would let me do that. Is there a native way to…
-
If a checkbox
Hello again. I need some help please with automation/formula on a project management sheet we use. (Action 1) I have a checkbox column called "SNAGS" When this is checked, I need a date column called "SNAG ADDED" to auto populate the date in which the checkbox was ticked by the project manager. (Action 2) Like wise, I have…
-
Ability to "lock" rows based on a response in a cell reference
Looking for a way to write a formula to lock rows if a cell has a specific value in it, or hide the rows. Any ideas?
-
tabs turn to dost/ellipses
Has anyone had an issue where the tabs within smartsheets turns to dots instead of having all the tabs at the top? It seems to happen periodically and I have no idea why, or how to switch it back to just have the tabs (I find the ellipses most annoying).
-
Automating updates from shared Excel doc to a Smartsheet doc
Is there a way to automate updates from a shared Excel file to a Smartsheet doc? I am currently manually entering data from an Excel file into a Smartsheet to update the information on a Sight. It would be great if the data was automatically updated in the Smartsheet when the shared Excel file is updated. Is that possible?…
-
Update existing smartsheet by excel
Hi, I have a smartsheet with 4 columns： building code, name, cs manager name and supervisor. I create this smartsheet by import excel. Excel has 4 same columns.. However, cs manager always change. We have 1000 buildings. Admin will send update list every week.. I know there is data live connector.. if I change info in…
-
How do I automate an import data from CSV so that I get service tickets for my team based on priorit
Hi All: I would like integration of our Helpdesk system with a Smartsheet file (i.e. Team Task List by Priority template). The Helpdesk system is our database of service tickets that my team will need to work on and resolve. Having the capabilities of Smartsheet such as team sharing, update requests, and card view would…
-
Date that works with drop down list
Is there a way to create a if statement that works based off the selection of a drop down list, and if that selection hasn't been made by a certain date is displays "incomplete"
