Using Smartsheet

Archives for December 2021

Discussion List

  • Nested If SmartSheet Formula For Symbols (R, G, Y)
    In Using Smartsheet
    =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 Symbo…
    23 1
    23 views 1 comment Most recent by Kelly Moore Using Smartsheet
  • Sheets vs Workspace
    In Using Smartsheet
    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 …
    SIS Profile Photo SIS
    Accepted
    28 2
    Accepted Answer 28 views 2 comments Most recent by SIS Using Smartsheet
  • User Management - Pro account
    In Using Smartsheet
    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 ke…
    Answered - Pending Review
    20 3
    Answered - Pending Review 20 views 3 comments Most recent by Julio S. Using Smartsheet
  • Display Specific Columns to Specific People in Shared Sheet
    In Using Smartsheet
    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 …
    Answered - Pending Review
    21 2
    Answered - Pending Review 21 views 2 comments Most recent by Purnima Gore Using Smartsheet
  • How do I remove my email from the tag line?
    In Using Smartsheet
    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…
    Accepted
    21 4
    Accepted Answer 21 views 4 comments Most recent by Stefanie Leonora Using Smartsheet
  • Line chart by Created
    In Using Smartsheet
    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 Seri…
    Accepted
    12 2
    Accepted Answer 12 views 2 comments Most recent by Lara Lehnerz Using Smartsheet
  • Automated Workflow - Emails not being sent to Project Sponsor for Approval
    In Using Smartsheet
    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/…
    Answered - Pending Review
    15 1
    Answered - Pending Review 15 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Time
    In Using Smartsheet
    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
    Answered - Pending Review
    16 1
    Answered - Pending Review 16 views 1 comment Most recent by hollyconradsmith Using Smartsheet
  • Automation: change cell value to a date when triggered
    In Using Smartsheet
    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…
    Answered - Pending Review
    23 4
    Answered - Pending Review 23 views 4 comments Most recent by Patrikas Using Smartsheet
  • Formulas for performance color formatting with benchmarks
    In Using Smartsheet
    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%.…
    Answered - Pending Review
    24 4
    Answered - Pending Review 24 views 4 comments Most recent by Mark Rhodes Using Smartsheet