-
Dashboards - Responsive Design?
Hi there, Wondering if there's a way to have dashboards adjust the layout responsively for mobile? Right now by default, on mobile it shows the entire dashboard and it's so tiny. Most other solutions the boxes stack on top of each other when the screen size reaches a certain width. Does anyone know if there's a way to do…
-
Form is not working
We have a lot of forms that get used daily, but we are having random problems with this one sheet/form, a couple different things will happen and it is at random: 1) if two forms are uploaded close to one another, only the first one will come in and the second one will not submit and it gets lost. 2) They will upload one…
-
User Management - Pro account
Hi, I am new to the Smartsheet Comunity. I would like to have a better understanding of the limitations of our PRO account with regards to sharing of workspaces and sheets. After creating a workspace and sharing some of it's content, I keep receiving messages such as ' This sheet has been shared with your plan's limit of…
-
How to make a sheet that only shows the last x entries of another sheet
Hello, What I am trying to do is track overtime hours taken for each department in our company. I have a sheet set up where our HR rep can submit a form for each week's value, but I need to display this in a chart, and that is where I am running into troubles. For the line graph widget, they would like it to show the last…
-
Creating a Conditional Formatting Rule that includes two columns
Hi! I'd like to create a conditional formatting rule that highlights rows red when Actual Hours exceed Projected Hours. Is there a way to do this? Thanks!
-
When Smartsheet form is returned it contains all columns in sheet, not just ones I used in the form
I have a Smartsheet with about 80 columns. When I make a form based on this sheet I may only use 10 of them as fields. When I publish the form, it looks good with only 10 fields. Yet when I get the filled out form returned, all the columns get returned including the ones that were NOT used as part of the form. It is super…
-
Has anyone used a template set for a Reservation tracker? Something to track coworking spaces?
ex. Coworking spaces, office space, etc.
-
Formulas for performance color formatting with benchmarks
I want one of the five benchmarks to be highlighted in correlation to what is “performance”. For this example, how can I get Benchmarks – 2 Star background color changed? The benchmark ranges are 0-54%, 55-63%, 64-70%, 71-77%, and 78-100%. I have 9 metrics to do this every month. Open to other ideas as well. I just need to…
-
Nested If SmartSheet Formula For Symbols (R, G, Y)
=IF([% Complete]@row < 0.7, "Red", (IF([% Complete]@row = 1, "Green", "Yellow"))) i.e. =IF(data < number, "TRUE Symbol Text", (IF(data = number, "TRUE Symbol Text", "FALSE Symbol Text")))
-
Sheets vs Workspace
Hi all, I am just not sure how the files are going to behave after I move them to the workspace from sheets. In the attached picture I have created a sheet name rush request from customers where I've reports, dashboard, and a sheet. The sheet has a form attached to it. To share do I have to move everything to the related…