Solution Center

Discussion List

  • VLOOKUP with IF and IFERROR Formula
    In Formulas and Functions
    I need to figure out the VLOOKUP formula within the Barrier Management Survey Status Sheet to where IF the Services Completed is “Door Program” (within the Shared Services Program Survey sheet), and the Facility Name matches, to then pull …
    Accepted
    28 3
    Answered ✓ 28 views 3 comments Most recent by Ashley Pierce Formulas and Functions
  • Personal consultant
    In Using Smartsheet
    Hello Everybody, I need assistance for building a solution for my company with smartsheet, I'd like to know if I can have support by a freelance expert or a partner. I'm in Italy, so it would be great if we could speak italian, but in engl…
    Answered - Pending Review
    32 1
    Answered - Pending Review 32 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Newbie Question: Want to Count "Product Name" but only if its date is in the future
    In Formulas and Functions
    Hello! I am very new to Smartsheets and I am trying to get the best use out of it. But, I am little stumped. I have a COUNTIF formula to count how many times a product name is mentioned in the sheet and then I used conditional formatting…
    Accepted
    16 3
    Answered ✓ 16 views 3 comments Most recent by Genevieve P. Formulas and Functions
  • How do I create a Index/Match formula w/ a condition across sheets?
    In Formulas and Functions
    I have a sheet with a bunch of site location data. This sheet includes a check box column showing if the site is Open (Checked = Open). I have another Project sheet where I want to pull in only the OPEN Sites and populate 3 columns from t…
    Answered - Pending Review
    25 2
    Answered - Pending Review 25 views 2 comments Most recent by Paul Newcome Formulas and Functions
  • Back up not complete
    In Using Smartsheet
    I requested a back up of my smart sheet on the 24th. It is still pending. Who do I contact to get that back up. Smart sheets won't let me attempt another back up with that one still pending.
    Accepted
    24 2
    Answered ✓ 24 views 2 comments Most recent by erinklee Using Smartsheet
  • Filter Including Parent Row(s)
    In Formulas and Functions
    I have created a filter for one of my sheets but would like to include the parent rows for the rows matching the filter criteria. The filter is for all rows with "February" as the invoice month - see the screenshot below for mor…
    Accepted
    24 2
    Answered ✓ 24 views 2 comments Most recent by ejrbean Formulas and Functions
  • Switch Formula
    In Formulas and Functions
    Hello, I have recently integrated a project plan from MS plan to Smartsheet's however I can't seem to get the auto RAG Switch function working working as it was in Project Plan. This is the formula I used. Can anyone please help :) Switch…
    Answered - Pending Review
    77 8
    Answered - Pending Review 77 views 8 comments Most recent by Andrée Starå Formulas and Functions
  • Formula for RYG Symbols in Child Rows to Update Parent Row
    In Formulas and Functions
    Hello, I'm wondering if there's a formula that could automatically update the parent row in a column that has RYG symbols? The parameters would be: -Green overall (in the parent row) if all children rows have green symbols? -Yellow overall…
    Accepted
    59 2
    Answered ✓ 59 views 2 comments Most recent by SteCoxy Formulas and Functions
  • Lock all rows in a sheet
    In Using Smartsheet
    Morning, I need to be able to stop anyone other than the admins of the sheet from adding rows but I also need to give users "commenter" status because I want them to be able to use the comments. How can I make sure the only ones …
    Answered - Pending Review
    22 2
    Answered - Pending Review 22 views 2 comments Most recent by renogawj Using Smartsheet
  • Cross Sheet Formula(s) w/ Yes, No, and Hold Decisions (IF & AND)
    In Formulas and Functions
    Hello All, I am trying to utilize a formula from a sheet (Parts Requests) to drive productivity and scheduling on another (Scheduling Board). I have created a formula [Report] to determine if the corresponding materials order has been rece…
    Answered - Pending Review
    30 1
    Answered - Pending Review 30 views 1 comment Most recent by Jeff M. Formulas and Functions