-
Filter on columns with values populated by a formula
Hello. After searching and coming up empty handed, I decided to post for help. I have columns in a sheet that are populated by VLOOKUP functions. Whenever I run a filter on one of those columns, all 1703 rows of my sheet are in included or excluded. As an example, if I set a filter on the "Effective Price To" = "is not in…
-
creating a form but not appearing in the Preview as a full form
I am a new user to smart sheet and I am working on creating a form.The problem that I am having is that all of the data for the forms are in there place but they are not appearing on forms when I do a preview of the form.
-
Sporatic Error, using the API.
Hello Everyone. I have another weird error. the spread sheet I am making is 35 columns across and 270 rows down. I do batch updates exclusively. And I also time my updates to the most updates are 160 a minute to not overload the Server(a 200 ms delay between updates). sometimes mid way through the updates Im getting *…
-
A Formatting Glitch, using the API.
Hello. I have developed a Script (Powershell), that will create a complete smartsheet. This smart sheet is created with colours based on various times on the source data, (Late, ontime, etc. ). My problem is when I update it again, the first column will keep the shading of the previous entries. even though I specify a…
-
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
