-
Smartsheet Save-Merge Errors
We have a high-traffic sheet that frequently has rows deleted, and when we ask the user about it, they have no idea they even deleted the row. I have reached out to smartsheet about this several times, and they said they can happen due to a "save-merge error", and to have users save and refresh the sheet often. Instead of…
-
Decimals added in drop down value from form
Hi, I have a column that can only be a drop down value. Unfortunately this value, project numbers, has a mix of both decimal and non-decimal values. For example, project 356 could be the main project, but has ancillary projects: 356.1, 356.2, ect. What I'm seeing is that in my project ID column Smartsheet has started…
-
Some text are in Cyrillic in Functions list.
Chatbot is not helpful, cant contact support directly. Some text (header) are in Cyrillic. @Diegob @Daniel Medved @Genevieve P.
-
Blocking users from moving rows while being able to edit...
Hi all! I use our smartsheet for a roll call log. I have employees moving rows and it's really screwing things up. I need them to be able to edit a column with toggles that say "here", "sick", "vacation" but not be able to move the rows. Is this possible at all? I cannot seem to find a workaround. Either the entire row is…
-
How can I stop my number field from rounding to the tenth place decimal?
I created a form and grid to track employee time. The employee submits a time request which is then sent to the supervisor using an update request for approval. The amount of time requested is added to a text field column and I have set the decimal place in this column to 0.00 multiple times. However, the grid keeps…
-
Custom Colors for Sheets
While it is wonderful that we now have the ability for custom colors on Dashboards, it would be truly helpful to also have this same ability in Sheets. It would be really helpful for some of our projects because our district uses certain colors to call attention to various district initiatives or our district instructional…
-
Continuously update a single cell from a regularly updating form?
Hi, I'm new to Smartsheet and was asked by a colleague if this was possible. We're tracking maintenance needs for on-site business assets that will be managed by a large group of employees. I have a sheet with each asset and their subsequent maintenance needs, plus fields for date of most recent update for each. I want to…
-
INDEX, MATCH, and OR Function
Hello, I am trying to use INDEX MATCH and the OR function. I'm referencing 3 other sheets try to say if we find x in any of these 3 sheets I want y from those sheets. x and y will only be present in 1 of the 3 other sheets. However every I do this I either get an error code or unparsable. These are a few of the formulas…
-
Starting
OK—After years of fortan and cobalt, I cannot even get started on Smartsheet. I am stupid. I loved the program Smartdraw and they ruined it. Yours looked great! I need simple instructions on how to start the process of building a chart or graph. Yes I get the detailed programed responses and ability to check with other…
-
How to auto populate cells
I am looking for a way to automate a cell so that when column A displays 9 'Days Open' (or between the values 0-14) the 'Req Age' will auto populate (or trigger) the ranges provided. Image below: I want the highlighted section to auto populate based on the value in 'Days Open'