-
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'
-
Smart Sheets has set me up with 2 different accounts and I cannot login properly
I am experiencing an issue where I seem to have two different accounts set up, and I am unable to log in properly. This is causing confusion and preventing me from accessing my Smartsheet account effectively. I need assistance in resolving this issue and consolidating or fixing the accounts so I can log in without any…
-
Software Onboarding, Risks assessments, budgets, and more
Hello, I would like a sheet that can track software onboarding from the beginning to update and all the way to end of life. I have an excel sheet that I converted to a smartsheet, but I feel it's a very one piece modifying any data. Seems that it should be a very simple process that I have a blueprint with smartsheets and…
-
How to analyze users that can be downgraded from Member to Contributor?
I am a new admin. How would I know who can be safely changed from Member to the new contributor role? Is there something or combination of items that can reviewed on Seat Type Report?
-
Portfolio Project List Sheet Summary
Hello! Week three of my Smartsheet journey in the consulting space, apologies if this is a very simple question. I have been tasked to get to know the new Portfolio section. When looking at the dashboard there is the high priority projects metric being fed by the sheet summary data from 'project list' sheet. This sheet…