Jeremy Myers
Jeremy Myers
Reactions
Discussions
- Anyone know what the null value is in Smartsheet when using the search and replace function? I tried, "", <> and all the usual tricks- no go. I want to search for a particular word in a string and rep…
- Running out of screen real estate is a problem. I find myself hiding or dragging columns to right and then having to unhide them or drag them back into the active area of the screen as needed. Request…
- We are managing complex workflows that are fixed as templates into Smartsheet. A typical workflow may have >100 major steps each of which has a bunch of sub-steps, forms, scripts or limks associated w…
- 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 fo…
- 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 bel…
- 1. Naming Columns: Changing a column name post-facto breaks reports and other stuff creating a lot of useless donkey work. Naming columns correctly at the get go is uber-important- think about it befo…
- For users of <user - can't share> level permission, turn off their ability to modify / duplicate filters on sheets that have been shared to them. The filters I give them with a sheet are the filters I…
- 1. When in Admin mode, ability to actually lock rows and columns on the sheet you are working on. Lackcing this, we throw away one seat on the three user system as we use Admin exclusively for program…
- Reqeusted Feature: On a sheet with many rows and cells to paint, the constant resampling of the source area is tedious, so.... Double Click on the format painter control holds the sample being painted…
- 1. I use filtering to hide rows with status <complete>, however when the filter is set, the sorting function is defeated. To resort, I remove the filter, sort and then reapply the filter. This is awkw…
