Formulas and Functions

Formulas and Functions

Discussion List

  • Naveen Srikakulam
    Accepted Answer Naveen Srikakulam 21 views 2 comments Most recent by Naveen Srikakulam
    First post 07/05/20,Last post 07/07/20
    Hi, I wanted to know how I can average the RYGB balls of the children cells. Something on the lines of if there is even 1 red, then turn the parent red. If there are no reds and at least one yellow then turn the parent yellow. If there are…
    Formulas and Functions212
    Naveen Srikakulam
  • kzulpo
    Answered - Pending Review kzulpo 10 views 3 comments Most recent by Andrée Starå
    First post 07/07/20,Last post 07/07/20
    Hi Everyone, I am trying to auto-populate a cell with a date based on status "Sent to Client" (dropdown) being selected. I have this functionality already working with the formula: =(IF([email protected] = "Sent to Client", …
    Formulas and Functions103
    kzulpo
  • productowner
    productowner 84 views 5 comments Most recent by [email protected]
    First post 04/04/19,Last post 07/07/20
    Hi, I'm working on getting all metrics for a large project into a dashboard in smartsheets. I've been tracking a burn up chart in google sheets, but think that connecting directly to it doesn't look clean. So in an attempt to copy it over,…
    Formulas and Functions845
    productowner
  • Arama Eruera
    Answered - Pending Review Arama Eruera 24 views 20 comments Most recent by Paul Newcome
    First post 05/07/20,Last post 07/07/20
    I have a status column with red, yellow and green. I'm needing a formula to change these colours when the percentage complete column gets below a certain percentage. i.e. 1-50% Red 51%-99% Yellow 100% Green
    Formulas and Functions2420
    Arama Eruera
  • Camie Keuck
    Accepted Answer Camie Keuck 20 views 2 comments Most recent by Camie Keuck
    First post 07/02/20,Last post 07/07/20
    Hi All I have a formula question - I am looking for the number of vacation days to populate when an anniversary date is between a certain date range. For instance with an anniversary date of 03/05/1997, if dates are between 03/05/1997 and …
    Formulas and Functions202
    Camie Keuck
  • Christine Lazzaro
    Answered - Pending Review Christine Lazzaro 13 views 2 comments Most recent by Paul Newcome
    First post 07/07/20,Last post 07/07/20
    Good Day, In my project. I have a Date Due column and a Planned completion date column. I would like the Planned Completion Date to turn red if it is after the Date Due, is this possible?
    Formulas and Functions132
    Christine Lazzaro
  • Gurmeet Mangat
    Answered - Pending Review Gurmeet Mangat 9 views 1 comment Most recent by Paul Newcome
    First post 07/07/20,Last post 07/07/20
    Hi Everyone, I am using data uploader and importing an excel file that uses this date/time format 2020-05-20T12:38:08.063. Looking for suggestions on how to extract the date efficiently. At the point of export into excel there is no optio…
    Formulas and Functions91
    Gurmeet Mangat
  • Steven Lagenour
    Answered - Pending Review Steven Lagenour 8 views 1 comment Most recent by Paul Newcome
    First post 07/07/20,Last post 07/07/20
    Hello, I'm looking to incorporate a simple round robin feature, i.e.: Column Header Titles: C1) Unique ID C2)A C3)B C4)C Step 1) Person S uses simple form that only requires Person S to enter a unique ID - the person enters that and saves…
    Formulas and Functions81
    Steven Lagenour
  • Lexie Ozolnieks
    Accepted Answer Lexie Ozolnieks 16 views 7 comments Most recent by Paul Newcome
    First post 07/07/20,Last post 07/07/20
    Hi! I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. Essentially, all I want to do is autofill the check box on sheet 2 once it is checked on sheet 1. Is this possible?
    Formulas and Functions167
    Lexie Ozolnieks
  • Michael Murphy
    Accepted Answer Michael Murphy 20 views 2 comments Most recent by Michael Murphy
    First post 07/04/20,Last post 07/07/20
    I have a sheet our team uses to track tasks/issues that need resolution as we move through project execution. Initially, I set the sheet up with a column to auto-number every new task/issue entry. This way the task/issue can easily be refe…
    Formulas and Functions202
    Michael Murphy
  • Prajna Jain
    Answered - Pending Review Prajna Jain 10 views 1 comment Most recent by Paul Newcome
    First post 07/07/20,Last post 07/07/20
    I tried Join Function to add text strings from 10 different column using following but no success: =JOIN([Region 1]:[Region 1], [Region 2]:[Region 2],[Region 3]:[Region 3],””) Can anyone help please? Thanks Prajna
    Formulas and Functions101
    Prajna Jain
  • Alexander Wirtz
    First post 03/26/19,Last post 07/07/20
    I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario.…
    Formulas and Functions2766
    Alexander Wirtz
  • Cheryl Lock
    Accepted Answer Cheryl Lock 14 views 3 comments Most recent by Paul Newcome
    First post 07/06/20,Last post 07/07/20
    Hi All, I'm fairly new to Smartsheet and I'm trying to set a text value based on a date range. Reading through all the responses it seems possible but a little messy. All I'm trying to do is automatically populate a Quarter value based on …
    Formulas and Functions143
    Cheryl Lock
  • Prajna Jain
    Accepted Answer Prajna Jain 17 views 15 comments Most recent by Stefan
    First post 07/06/20,Last post 07/07/20
    I have a condition where in the formula should check the text in CELL A and return value based on the assigned values and should leave the formula cell BLANK if none of the condition is satisfied. I tried it through spreadsheet and the for…
    Formulas and Functions1715
    Prajna Jain
  • mmschneider113031
    Accepted Answer mmschneider113031 29 views 2 comments Most recent by mmschneider113031
    First post 07/01/20,Last post 07/07/20
    I am trying (what I thought was a simple formula) to countif using multiple criteria. I have a drop-down column. I want to calculate the number of "yes" and number of "Maybe - Depending on caseload" for the CHILDREN. …
    Formulas and Functions292
    mmschneider113031
  • Wini
    Answered - Pending Review Wini 22 views 5 comments Most recent by Andrée Starå
    First post 07/03/20,Last post 07/07/20
    I don't know if this is possible at all. So I have a column and it's the importance of the tasks in the sheet. I have another sheet that has a summary and tally up how many tasks are there for each severity level. Someone did this manually…
    Formulas and Functions225
    Wini
  • Joselyn Davila
    Dashboard Viewer FilterAccepted Answer
    Accepted Answer Joselyn Davila 318 views 5 comments Most recent by Gary Van Rensburg
    First post 01/13/20,Last post 07/07/20
    I attended Engage last year and a new advanced option was announced called "Dashboard Viewer." I can not find this on any of my dashboards. Is there anyway I can filter the data on by dashboard by different users viewing it? …
    Formulas and Functions3185
    Joselyn Davila
  • Lewis Waters
    Answered - Pending Review Lewis Waters 32 views 5 comments Most recent by Stefan
    First post 07/02/20,Last post 07/06/20
    Hi, I am trying to add a bulk of emails into a smartsheet group. It is suggested that you can do this by pasting email multiple email addresses into the " add members" fiels; however it just returns " please enter a valid em…
    Formulas and Functions325
    Lewis Waters
  • Marion1972
    Answered - Pending Review Marion1972 13 views 8 comments Most recent by Marion1972
    First post 07/06/20,Last post 07/06/20
    Hi, I am trying to ad a specific condition IF(TD<[@[DUE DATE]]+7,"PIPELINE" to an existing formula. However, the existing condition IF(TD<[@[DUE DATE]],"CURRENT" is interfering with the addition, and I cannot figu…
    Formulas and Functions138
    Marion1972
  • SoS | Dan Palenchar
    Accepted Answer SoS | Dan Palenchar 32 views 2 comments Most recent by SoS | Dan Palenchar
    First post 06/22/20,Last post 07/06/20
    Hi everyone, I am trying to use Zapier to add the date to a row that reflects when a comment was last added in that row. I thought I got it up and working, but ran into an error when I moved from testing to implementation. I used the "…
    Formulas and Functions322
    SoS | Dan Palenchar
  • Saadia Ashraf
    Accepted Answer Saadia Ashraf 40 views 34 comments Most recent by Saadia Ashraf
    First post 06/16/20,Last post 07/06/20
    Hello, I'm trying to figure out how i can count or which formula i can use to count how many people selected their desired choices from three different categories (single-select dropdown) that falls under 3 different groups. I created a fo…
    Formulas and Functions4034
    Saadia Ashraf
  • aschneiderheinze74206
    Accepted Answer aschneiderheinze74206 51 views 35 comments Most recent by Paul Newcome
    First post 06/20/20,Last post 07/06/20
    I am building a dashboard for each of the colleges at my university. I originally created a Smartsheet for each college that lists all of the courses in each of the programs in the college, documenting whether or not we have a course maste…
    Formulas and Functions5135
    aschneiderheinze74206
  • KC Fife
    Accepted Answer KC Fife 10 views 2 comments Most recent by KC Fife
    First post 07/06/20,Last post 07/06/20
    Hello, for some reason I have one formula using a cross sheet reference that comes over as a percentage when the rest come over as values which is what I want. (Image) (Image) (Image) I really don't understand why the "complete"…
    Formulas and Functions102
    KC Fife
  • Matt Foss
    Accepted Answer Matt Foss 21 views 4 comments Most recent by Matt Foss
    First post 07/02/20,Last post 07/06/20
    I am attempting to create an automatic status update that is driven by different options selected in multiple other cell columns. For example: I want my Status column to indicate "Assessment" if another column regarding the asses…
    Formulas and Functions214
    Matt Foss
  • Chris Rea
    Answered - Pending Review Chris Rea 38 views 16 comments Most recent by Paul Newcome
    First post 06/08/20,Last post 07/06/20
    I've tried multiple searches and haven't found the right keyword/tricky phrase to answer my question. I am using a form for submissions and trying to calculate how long a trend has been occurring. Right now my working formula is this: =…
    Formulas and Functions3816
    Chris Rea
  • Megan Cunningham
    Accepted Answer Megan Cunningham 31 views 2 comments Most recent by Megan Cunningham
    First post 07/02/20,Last post 07/06/20
    Hello! I am trying to count projects by person overtime (monthly) in order to show how many projects a person on my team has going on simultaneously. I am using two date columns- Kick off date (KO) and implementation date (Imp Date) with …
    Formulas and Functions312
    Megan Cunningham
  • Dean Ellis
    Answered - Pending Review Dean Ellis 20 views 2 comments Most recent by Dean Ellis
    First post 06/25/20,Last post 07/06/20
    Hi, I've been developing a number of sheets for an organisation. Id like to know if there is a feature where The Mobile app can use smart sheet offline in the field where there may be no access to the internet and then uploading the change…
    Formulas and Functions202
    Dean Ellis
  • Hani Al Ashkar
    Accepted Answer Hani Al Ashkar 18 views 3 comments Most recent by Genevieve P
    First post 07/02/20,Last post 07/06/20
    I imported a sheet with the below equation from Excel. However,it comes back with #UNPARSEABLE and i'm not sure where it's going wrong on Smartsheet, any help or advice would be highly appreciated. =COUNTIFS([Visit Interval]1:[Visit Inter…
    Formulas and Functions183
    Hani Al Ashkar
  • Chandler Koury
    Answered - Pending Review Chandler Koury 142 views 6 comments Most recent by Genevieve P
    First post 01/29/20,Last post 07/06/20
    Hi there! I am trying to figure out how many projects start in the current month for a designated department. This formula works: =COUNTIFS(Department:Department, "Marketing", Start:Start, IFERROR(MONTH(@cell), 0) = MONTH(TODA…
    Formulas and Functions1426
    Chandler Koury
  • Admin Account
    Accepted Answer Admin Account 8 views 3 comments Most recent by Genevieve P
    First post 07/04/20,Last post 07/06/20
    Hello - we have a sheet with Health symbols for the Tasks which are children under Phases of a project. I'd like to be able to indicate on the parent cells of the Health column if there is a non-green symbol among their Children cells in …
    Formulas and Functions83
    Admin Account