Formulas and Functions

Archives for July 2020

Discussion List

  • How to auto-populate hidden values for forms?
    In Formulas and Functions
    Hello, my name is Matthew, and I am working on a project that gathers data from clients. The goal is to receive documents from them and have them uploaded to SmartSheet. I would like to be able to send them a form based off a contact cell,…
    Answered - Pending Review
    36 4
    Answered - Pending Review 36 views 4 comments Most recent by Andrée Starå Formulas and Functions
  • Avgerages, assigning a value to text, and parent/child formula
    In Formulas and Functions
    I'm attempting to insert a formula into parent rows that assign a % complete based on entries on child rows. The child rows responses are locked based on task completion. The options are: "Yes, In-Process, and Not Started." I've …
    Answered - Pending Review
    11 5
    Answered - Pending Review 11 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Multiple IF or Match
    In Formulas and Functions
    Have a scenario that I want say if column A matches Column B, then enter value column C, If Column A matches, Column D, then enter value column E, If Column A matches Column F, Then enter value column G. Is this better done through some so…
    EMA Profile Photo EMA
    Answered - Pending Review
    11 6
    Answered - Pending Review 11 views 6 comments Most recent by Paul Newcome Formulas and Functions
  • Conditional Formatting Stopped Working
    In Formulas and Functions
    I have some very basic Conditional Formatting rules based on a System Date "Submitted". They were working fine, but today they just stopped working. I have attached a screen shot of the rules. Any idea why this would suddenly sto…
    Answered - Pending Review
    78 2
    Answered - Pending Review 78 views 2 comments Most recent by Paul Newcome Formulas and Functions
  • How to make multi-select selections be clickable links (in a report or dashboard)
    In Formulas and Functions
    Hi there, Is it possible to add hyperlinks to each option in a multi-select column? For me this is less important in a Sheet than in a Report (or Dashboard), but I presume this would need to be set up in a Sheet for it to flow to a Report …
    Answered - Pending Review
    122 4
    Answered - Pending Review 122 views 4 comments Most recent by Andrée Starå Formulas and Functions
  • Adding formula to existing formula for status change
    In Formulas and Functions
    Hi everyone, I currently have a formula in my status column that auto-update depends on the percentage completion. Anything that is 0 is Not Started, and greater than 0% and less than 100% is Green (G), and anything that is 100% is Complet…
    Accepted
    12 2
    Accepted Answer 12 views 2 comments Most recent by Nathan Nguyen Formulas and Functions
  • Add
    In Formulas and Functions
    I have 3 Sheets: #1 = Closeouts, #2 = Annual Incentives; #3 - Incentive Distribution When a closeout is completed, data is entered on Sheet#3 - Inc. Dist. I have a Data Mesh to pull the data from the # 3 to populate Info on #2 Ann Inc.…
    Accepted
    13 2
    Accepted Answer 13 views 2 comments Most recent by Debbie Petersen Formulas and Functions
  • Formula: Turn Sprint # into Date or vice versa
    In Formulas and Functions
    I'm attempting to create a formula that will translate Start Date into sprint number. In my spreadsheet there is a column for Sprint that I'd like to populate it with Sprint 1, Sprint 2, Sprint 3, etc based on date. For example Sprint 1's …
    Answered - Pending Review
    25 2
    Answered - Pending Review 25 views 2 comments Most recent by Paul Newcome Formulas and Functions
  • Multiple IFs Statement: Number to Name
    In Formulas and Functions
    We currently use numerical codes to denote our teams that are synced from JIRA. Those numbers are reflected in a column which I'd like to translate into the relevant team names. Team Column: 107 = IT-HelpDesk 108 = IT-EnterpriseApplication…
    Accepted
    12 4
    Accepted Answer 12 views 4 comments Most recent by Andrée Starå Formulas and Functions
  • How do I use conditional formatting to highlight upcoming dates that do not match?
    In Formulas and Functions
    For example, I am using cell linking to pull in two different large pieces of data from two separate sheets. What I'm trying to resolve is how to flag column 3 date if it does not match column 2 date. I want to highlight the dates that d…
    Answered - Pending Review
    47 1
    Answered - Pending Review 47 views 1 comment Most recent by Andrée Starå Formulas and Functions