-
Scroll wheel not working with system settings
I swear I posted this somewhere else, but cannot find it now. Opening a new post. I am able to scroll, but I find that Smartsheet does not respect the settings of the mouse scroll wheel while I am in a sheet or report. If I go to the home tab, or scroll around in my favorites, I can see that one click of the wheel ~= the…
-
Removing Answer Choices from Webform
I am making webform for event sponsorships. I would like the sponsors to select which events they want to sponsor - but each event can only have one sponsor. Is there a way to have a dropdown menu that eliminates choices once someone else has selected them? For instance, if I have sponsor event A, event b and event c, then…
-
"Move to Another Sheet" Changed?
Has the "move to another sheet" functionality changed? In the past, it has always copied the rows to the chosen sheet and deleted them from the source sheet. I have tried it three times this morning and managed to copy them three times to the designated sheet and they still remain in the source sheet. And yes, I am sure I…
-
Formula for a carriage return within a cell
Hello i have this formula for milestones, however I would like to format it so that the "Milestone Count, Milestone Reached, Milestones to Go are all lined up to the left of the cell. I cannot change the size of the cell as there are multiple tasks in that same column. ="Milestone Count. . . . . . . " + COUNT([Notify…
-
Pasting into an Auto-number does not auto-number in sequence
Hi all, I just pasted a list of about 20 records into a autonumbered sheet, The auto numbers did not appear in sequence. The paste is as per the original sequence, the autonumber field, jumps around with out rhyme or reason? e.g the fields sequence 179, 180, 181, 184, 185, 189, 190, 191, 192, 194, 195, 197, 200, 188, 193,…
-
Automatically update related tasks when one date changes
Hi! My team is using Smartsheet for project management, and I want to know how to update due dates for tasks that are related. For example, if my original due date is 1/1/17, and there are several other tasks that are related to the starting date (edit, layout, print, etc.), if I change the date of one of those tasks, how…
-
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…
-
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…
-
Parent Relation on Progress %
Hi, i am trying to figure out how to create a parent relationship using the progress bar (0%, 25%, 50%, etc...) without having to enter 2 dates. I have a parent with 6 children rows under it. If i choose the progress bar as a colum property from symbols and select progree in the 6 children, I want the average to be…
