-
Smartsheet not triggering zaps
Smartsheet's tech update this morning wasn't very clear about what problems the app is having. Has anyone else experienced problems with the Zapier integration. Adding new rows is not triggering new zaps, even if I manually select "Run" from the menu.
-
Tip / Tricks - Simplify Date Management w "Days from Today" calculation.
Looking at long column of dates is cognitively challenging, but everyone understands a range of numbers, negative to zero and then positive. I originally used this scheme to simplify my conditional formatting setup but found that users really liked it so now I keep it visible. It also makes reports much easier to…
-
Index Rows - Idiot Proof Your Sheets!
What to do when some fool decides to <sort> a sheet just to see what happens? When creating a master sheet, inset a hidden column "Z_Row_Index. Enter "1" in the first cell and then "2" in the cell below. Highlight those two cells and drag the little widget at the bottom right of the lower cell. This will drag-fill the line…
-
Using a homeless "By Name List" and setting proper permissions
I work for United Way and we are currently incharge of managing our communities homeless "By Name Lists". In a nutshell, these are lists of current homeless people in our community, and is a way for agencies that provide housing to work together in helping people get housed. Also, because we're a non-profit, we only have…
-
Informal user survey: task completion check boxes
Hi, I keep running into systems that have a variety of names for check box columns that are intended to mark task completion. If you wouldn't mind, please follow this link: https://app.smartsheet.com/b/form?EQBCT=5b8cc9b3e70c42b2b20c795cf2a37877 to tell me the column name you use (or if you don't use one). I appreciate…
-
Enhancement Requests: Community / Help search
The number of threads on the Community has grown since i became active. In March 2016, there were about 2300 threads. There's more than double that now (466 pages x 10 per page) I'd like to see some improvements so I can find things more quickly. The search I am talking about is either here: Thanks Craig
-
Drop down selection box legend
It would be really nice if when you set up a multiple choice slection box and you are using acronyms, that you could put a short description by each. I'm always trying to make columns narrower to allow more columns on the screen without having to use a slide bar to see more. I set up one column that indicates which…
-
CAB Change Advisory Board
Anyone has an idea of CAB template/format. The company's requirenemnts is to track and report on tickets in their current review, approved/rejected/deferred. Status of in progress or completed. CAB takes place twise a week so the date of CAB is imprtant for historical purposes as well. It is not difficlut to create in…
-
Combining calendars with work plans
Hello, My organization has the team plan (not Business). Is it possible to create a graphical calendar view that reports/displays results with a traditional project/work plan by department or function with tasks/activities? If so, can you only create this on the same page within Smartsheets using Sights? I suppose it would…
-
auto populate due dates
I want task due dates to auto populate based on one date that I enter as the event date. For example, I will set an event date and certain tasks will be due 2 weeks prior to event date. When I create individual event sheets, I want to enter that event date and then due dates will auto populate for each event based on that…
