Formulas and Functions

Archives for October 2019

Discussion List

  • Dashboard Widget Chart Issue with Multi Select
    In Formulas and Functions
    I have a dashboard chart widget that was pulling data from a single select option. I've now changed it to multi-select but I see that my chart isn't pulling in that item at all when there are more than 1 item selected. Am I missing somethi…
    426 9
    426 views 9 comments Most recent by Paul Newcome Formulas and Functions
  • Formula to Automate Stage
    In Formulas and Functions
    Hello - I am trying to figure out if there is a way to automate the selection of one of three stages (Not Started, In Progress, Completed) based on Start and Due date columns.  Activities with a Start Date in the future would be 'Not Sta…
    38 8
    38 views 8 comments Most recent by Paul Newcome Formulas and Functions
  • Return value in Parent Cell for Child value
    In Formulas and Functions
    I have been trying to use the Index & Match function to automatically populate in the Parent row based on the status of a Child row, however, the formula will not pick up the Child status. For example, I want the STATUS column of the …
    222 3
    222 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Dynamic reporting across multiple sheets
    In Formulas and Functions
    My organization recently moved from Google sheets to Smartsheet. We were tracking the number of jobs completed by each team member in the last week. We had multiple groups of jobs that would be uploaded as a new tab on the sheet. The repor…
    364 7
    364 views 7 comments Most recent by Andrée Starå Formulas and Functions
  • AVG(Collect) Formula help with date range
    In Formulas and Functions
    Is there a way I can give a date range in the formula below so that it averages between dates 8/21/19 - 10/29/19 =AVG(COLLECT({Nexus Dependencies Range 5}, {Nexus Dependencies Range 1}, "The Scrum Lords", {Nexus Dependencies Ran…
    79 3
    79 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Calculate Date Employee turns 18
    In Formulas and Functions
    Can anyone provide a formula that calculates when an employee turns 18, based on a DOB (date of birth) cell.  I've reviewed the forum and found formulas that return an age, but we need a date so we can set up a notifier email to alert payr…
    16 1
    16 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Formula Help!!!
    In Formulas and Functions
    I'm having issues with making this formula work for the RYGB Balls. Any glaring mistakes? -Green – An open request that was received 1-5 days ago. -Yellow – An open request that was received 6-10 days ago.  -Red – An open request th…
    11 3
    11 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Formula issue for conditional formatting
    In Formulas and Functions
    I am trying to set up a formula to allow for conditional formatting but having some problems.  This is the formula I'm trying: =IF([Actual]19 >= [Target]19, IF([Actual]19 < SUM([Target]19 * 0.1), IF([Actual]19 > SUM([Target]19 *…
    14 4
    14 views 4 comments Most recent by Mike Wilday Formulas and Functions
  • Forms/Formulas
    In Formulas and Functions
    Hi,    I have a Form/Dashboard on Smartsheet to book site induction on the project I am currently working on (see attached image). Just like every other Smartsheet forms, once the form is filled in it feeds into the sheet. Is it possible…
    33 5
    33 views 5 comments Most recent by Andrée Starå Formulas and Functions
  • Conditional Formatting if Checkbox is Checked
    In Formulas and Functions
    Hello everyone, I created a checkbox column with 3 cells set to toggle on and off conditional formatting rules. My idea is to paint certain cells if certain conditions are met AND one of the 3 cells is checked.  I'm doing this mainly fo…
    4297 8
    4.3K views 8 comments Most recent by Paul Newcome Formulas and Functions