-
hh:mm:ss Time Tracking in Smartsheets? (Probably not possible)
Howdy everyone! I've got a pernicious little problem that I'm wondering if anyone has any ideas about. My team and I currently track all of our break/fix help tickets in one dedicated "backlog" sheet. Each task that we need to complete is added to this sheet, gets prioritized, gets worked on, gets clarified (if needed),…
-
Screen blurs for lengthy formulas, or multiple parentheses
Whenever, I try to use if statements or so, the screen blurs and is very irritating to the eye. Could this be fixed ? Example : =IF(AND([Total Man hours]7 >= 1, [Total Man hours]7 <= 16), 1, IF(AND([Total Man hours]7 >= 17, [Total Man hours]7 <= 39), 2, IF(AND([Total Man hours]7 >= 40, [Total Man hours]7 <= 120), 3,…
-
Formula help
Hello, I have been trying to work this one out. Attached is a picture of the column that i wish to tally. This column is a checkbox column and there are multiple parent lines (these are the colours lines) The top line is the grandparent line the white rows are the children. So what you see is each children row has some…
-
Link to Unknown Sheet
We are experiencing issues with "links to unknown sheets" popping up. See image attached. * We are saving the sheet that the link is going to as a new sheet (almost like using it as a back up), but we are clicking so that the "links do not carry over", so it should not be happening from this task. * We have no way of where…
-
Source Table for multiple sheets individual drop down columns
Good Afternoon, I have multiple sheets (50+) that utilize drop downs to look up data specific to an individual record. The individual record for example would be a location number. We add locations on a monthly basis and i need an easy way to update the drop down option from a central location, vs having to update each…
-
Setting character limits on SS Cells or form area
Does Smartsheet allow you to set a restriction on the amount of characters allowed within a cell or in the txt box within forms? Thank you
-
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…
