-
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…
-
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…
-
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…
-
How do I remove my email from the tag line?
Hello, I have created workflow to approve certain requests but i noticed that my e-mail is included in the tag line of the approved email that gets sent to users. This is pictured below where it is says "changes made by...." and includes my e-mail address. How can I remove this as I do not want persons to have access to my…
-
Line chart by Created
Hello, I am looking to add a line chart to my dashboard that shows how many projects have been opened by month for the past year. Any suggestions on how to accomplish this? I was also looking at the Work Insights new feature the Time Series widget but Created is not a column option. Any assistance will be greatly…
-
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.…
-
Time
Hello, I am curious if there is a way to set a rule of some sort where you can make a row change color if it goes past a lets say 7 day window. Is this possible? Thank you
-
Automation: change cell value to a date when triggered
Hello, I was wondering if it is possible to approach it differently since 'change cell value' to a date is not possible, it is only possible with columns: text/number, dropdown and checkbox in my case. I wanted to have an automation when a person which could be one of two following: contractor or permanent and I want it to…
-
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…
