-
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…
-
Display Specific Columns to Specific People in Shared Sheet
Hi I am trying to work out how to only share the columns with someone that I want them to see (not in an update request) or in a report. I have a sheet that has answers to questions from suppliers and that has three different responses to make it easier to view. For example Question 1: How would you deliver this project…
-
Automated Workflow - Emails not being sent to Project Sponsor for Approval
I'm using the PMO Template Set to set-up a new Project Management Office. I have set-up two separate workspaces/projects for development & testing. In one of the workspace/projects, the automation works fine. In the other workspace/project, the automated workflow does not send the email to the Project Sponsor for approval.…
-
Customizing axis labels on line graph
When creating a line graph widget, is there a way that I can customize the values of the vertical axis? I want to scale to the date, but I also only want whole number values and only positive values. How can I modify the labels to accommodate this?
