Formulas and Functions

Archives for April 2020

Discussion List

  • Can you auto populate task dates based on the entire project end date?
    In Formulas and Functions
    I have different marketing tasks where their completion dates revolve around an entire projects completion date. For example, there are tasks that need to be completed 10 days before project completion date, 20 days prior, 30 days prior, e…
    Answered - Pending Review
    27 2
    Answered - Pending Review 27 views 2 comments Most recent by Andrée Starå Formulas and Functions
  • Need to apply conditional formatting to a parent row when a child row date is in the past
    In Formulas and Functions
    In this particular instance, I want the "Production" row to display in Red/Bold since it has subtasks that are past due and not ticked "completed". Is there a way to do this easily? (File)
    Answered - Pending Review
    11 3
    Answered - Pending Review 11 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • IF Checked, Assign Auto Number
    In Formulas and Functions
    Hi there! I'm no excel or Smartsheet formula wiz but I'm hoping someone here can help me figure out a way to do the following: I'd like an auto-populated number to appear in a row when the "Estimate" box is checked. There will be…
    Answered - Pending Review
    25 7
    Answered - Pending Review 25 views 7 comments Most recent by Andrée Starå Formulas and Functions
  • Create a Duplicate Flag
    In Formulas and Functions
    Hello, I am trying to create a flag that turns red when a duplicate name is entered. Here is the formula I have so far, but it keeps telling me it is "#Unparseable" =IF(COUNTIF([Client/Resident Name]:[Client/Resident Name]@cell)…
    Accepted
    21 1
    Accepted Answer 21 views 1 comment Most recent by Maria Watters Formulas and Functions
  • Convert duration in a number column to make calculations
    In Formulas and Functions
    (Image) How could I covert the duration information/data in number so I can calculate variances in numbers or in percentages? I had to create a column and type each number, but I can not do that in 50 different worksheets. Is there any for…
    Answered - Pending Review
    30 5
    Answered - Pending Review 30 views 5 comments Most recent by Suveer Sadanand Formulas and Functions
  • How can I use Smartsheet to help us with my Pitch deck?
    In Formulas and Functions
    As a radiopharmaceutical company, we have many Pitch decks in order to get grant money. Over the years, I have multiple pitch decks. Is there a way that Smartsheet could somehow help me organize those pitch decks (presentation is in powerp…
    Accepted
    11 5
    Accepted Answer 11 views 5 comments Most recent by Andrée Starå Formulas and Functions
  • Parent cell - Status symbol total
    In Formulas and Functions
    (Image) Hi there, How can the parent cell (circled in blue) automatically reflect the correct color/symbol concerning the tasks below? When I say automatically, I refer to do it by default, not me selecting the symbol all the time. Can th…
    Answered - Pending Review
    21 1
    Answered - Pending Review 21 views 1 comment Most recent by Ryan Nix Formulas and Functions
  • countif by date references
    In Formulas and Functions
    I have a column of dates in one sheet called {Dates} In a second sheet I want to analyze the dates based on if they fall into a specific calendar month I have a column called Y (year) filled with data like 2020, and a column called M (mont…
    Accepted
    72 3
    Accepted Answer 72 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • COUNTIF Help
    In Formulas and Functions
    Hello, Is there a way to count the number of times a contact appears in a certain column, if there are multiple contacts in some of the cells? (Image) For example, I can use COUNTIF to see how many times Charles appears in cells where it i…
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Help with IF(INDEX(MATCH
    In Formulas and Functions
    Hi all, First question in the forum. I'm in need of help with an INDEX(MATCH( formula that I've been using but now need to make conditional on another column. Essentially, I only want the INDEX(MATCH( formula to return a value when a col…
    Accepted
    493 27
    Accepted Answer 493 views 27 comments Most recent by Paul Newcome Formulas and Functions