Formulas and Functions

Archives for June 2020

Discussion List

  • SUMIF using CONTAINS from a different sheet
    In Formulas and Functions
    Hello! I am trying to sum from a certain column when another column contains the word "RSMAS", this is what I am trying and it doesn't seem to work: =SUMIF({Completed Request - Safe Return to Campus Range 2}, CONTAINS("RSMA…
    Accepted
    22 5
    Accepted Answer 22 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • How far can Conditional Logic go to screen? Screen does not work
    In Formulas and Functions
    I am trying to use: CONTAINS(OnePt, @cell), [OnePt]:[OnePt] Essentially I am trying to use Location - OnePt - to see if there is a record of OnePt input into a record. If I cannot use the logic, can you explain the scenario and cell in a c…
    Answered - Pending Review
    12 9
    Answered - Pending Review 12 views 9 comments Most recent by Paul Newcome Formulas and Functions
  • COUNT IF with date and multiple criteria
    In Formulas and Functions
    I am trying to pull data from another sheet and would like it to count the criteria IF the date is less then a specific date. This is the start of the formula. When I do just the date portion it works fine, as soon as I add in the other cr…
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Adding Columns with Dates
    In Formulas and Functions
    Trying to add up two different columns- I think I got the first figured out, it would be a sum of all charge offs w/in a certain quarter this was my formula: =SUM(COUNTIFS({Credit Card Charge Offs Range 1}, AND(IFERROR(MONTH(@cell), 0) =…
    Accepted
    11 3
    Accepted Answer 11 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • SUMIF on separate Sheet
    In Formulas and Functions
    Hi, I'm new to the community and fairly new to Smartsheet and already hit a wall and finally decided to reach out to the community for assistance! I have a sheet with one column called "Broker" with approximately 30 names and one…
    Accepted
    21 3
    Accepted Answer 21 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Ad hoc reporting
    In Formulas and Functions
    In forms or reports is ther a way for user to enter a variable? Situation: Sheet contains thouseands of employee names and corresponding information. Do not want users directly in sheet so they need to update information via report. Is …
    Accepted
    21 3
    Accepted Answer 21 views 3 comments Most recent by Tanya Brooks Formulas and Functions
  • Contact List using DataMesh & Concatenate
    In Formulas and Functions
    Hi, I have added 2 columns to a data sheet, one for Analyst Name and one for the Analyst Manager. I have brought in the email addresses of both of these by DataMesh. I want to be able to apply a current user filter to a certain column whi…
    Accepted
    268 3
    Accepted Answer 268 views 3 comments Most recent by Genevieve P. Formulas and Functions
  • Need help with RYG status formula
    In Formulas and Functions
    =IF([% Complete]@ROW<.7, "RED"), IF ([% Complete]@ROW< 1>.7, "YELLOW"), IF([% Complete]@ROW)=1, "GREEN"),""))) If below/above certain percentages, attempting to change the ball to red/yello…
    Accepted
    11 3
    Accepted Answer 11 views 3 comments Most recent by Genevieve P. Formulas and Functions
  • How can I add character count, like in the content calendar template?
    In Formulas and Functions
    I'm trying to add the function of character count in my template. It's the same feature that's used in the Content Calendar feature. What is the formula?
    Accepted
    61 1
    Accepted Answer 61 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Sum incremental cells
    In Formulas and Functions
    Hi, I have 30 row in Col 2 and I want to return value in Col 3 at increment of each row.
    Accepted
    21 14
    Accepted Answer 21 views 14 comments Most recent by Paul Newcome Formulas and Functions