Formulas and Functions

Formulas and Functions

Discussion List

  • Joel Richardson
    Accepted Answer Joel Richardson 12 views 2 comments Most recent by Joel Richardson
    First post 07/01/20,Last post 07/05/20
    I have a normal/typical/simple project plan sheet: task, duration, assigned to. In lieu of having the Proj Mgr ask the engineer, how much he accomplished on the task and then putting that time into the project plan manually, is there a w…
    Formulas and Functions122
    Joel Richardson
  • Gillian Pritchard
    Answered - Pending Review Gillian Pritchard 9 views 1 comment Most recent by Genevieve P
    First post 07/03/20,Last post 07/05/20
    Is it possible to you use a COUNTIFS formula referencing multiple sheets?
    Formulas and Functions91
    Gillian Pritchard
  • Jason Klaver
    Answered - Pending Review Jason Klaver 11 views 2 comments Most recent by Genevieve P
    First post 07/03/20,Last post 07/05/20
    Good morning, I am looking to embed and IF statement that includes ISNUMBER. If I keep the statements separate they both work, but when I combine them together I get and "UNPARSEABLE".  Here is my Statement "=IF(ISNUMBER([P2…
    Formulas and Functions112
    Jason Klaver
  • Cindy Doucet
    Accepted Answer Cindy Doucet 18 views 5 comments Most recent by Andrée Starå
    First post 07/03/20,Last post 07/03/20
    Hi, I'm looking for formula help with the at risk flag. Goal: If target finish date is within 7 days OR past due, and % complete is less than 100%, then activate flag. when % complete equals 100%, flag can deactivate. =IF(AND([Target Fini…
    Formulas and Functions185
    Cindy Doucet
  • Joshua Chesner
    Contact List FormulaAccepted Answer
    Accepted Answer Joshua Chesner 16 views 4 comments Most recent by Andrée Starå
    First post 07/03/20,Last post 07/03/20
    I have a column in a sheet that I named Assigned To. It pulls a contact based off an IF statement dependent on another cell in the sheet. The formula works properly and plugs in the contact appropriately with their icon as well. I have a…
    Formulas and Functions164
    Joshua Chesner
  • heze
    If funct quizQuestion
    Answered - Pending Review heze 9 views 1 comment Most recent by SoS | Dan Palenchar
    First post 07/03/20,Last post 07/03/20
    Am trying to solve this query without succeeding please help .if value in cell B is greater than cell A values , divide by 2 and return answer in cell C. if Cell A value is greater than cell B value return A value in C. is the above quer…
    Formulas and Functions91
    heze
  • Kalifa Telintelo
    Answered - Pending Review Kalifa Telintelo 9 views 2 comments Most recent by Kalifa Telintelo
    First post 07/02/20,Last post 07/03/20
    I have a kanban board and want to limit the number of "cards" that can be in the "WIP" lane. I also have another file where I have ABCD ranked projects, and want to limit how many can be an "A" project. is the…
    Formulas and Functions92
    Kalifa Telintelo
  • Leann Gibson
    Answered - Pending Review Leann Gibson 42 views 3 comments Most recent by sravya.gupta127326
    First post 06/11/20,Last post 07/03/20
    Has anyone used the Risk Assessment Matrix template and then created a dashboard summary view? I would like to create a summary like the blow that rolls up all the risks. (Image)
    Formulas and Functions423
    Leann Gibson
  • Wini
    Accepted Answer Wini 17 views 4 comments Most recent by Peter Harink
    First post 07/02/20,Last post 07/03/20
    So, in one of the sheets we are working on, the date for the today function always changes back and forth (a day difference). We think it's because a member of the team has a different timezone so whenever they make changes to the sheet, n…
    Formulas and Functions174
    Wini
  • Anna Keeton
    Accepted Answer Anna Keeton 15 views 2 comments Most recent by Anna Keeton
    First post 07/02/20,Last post 07/03/20
    Hey all, Trying to make a simple task management sheet, using today's date and the task status to define a Red, Yellow, Green or Grey ball. If end date is today or later, AND status is not complete or cancelled, green If end date is today…
    Formulas and Functions152
    Anna Keeton
  • Jae Wyld
    Answered - Pending Review Jae Wyld 20 views 3 comments Most recent by Andrée Starå
    First post 06/22/20,Last post 07/03/20
    Hi everyone, I need some help with a helper column I created to resolve an issue. I am currently pulling together 4 non-adjacent multiple-contact columns into one string by using =[column1]1 + [column2]1 + [column3]1 + [column4]1 in a tex…
    Formulas and Functions203
    Jae Wyld
  • Stacy Calhoun
    Answered - Pending Review Stacy Calhoun 27 views 11 comments Most recent by Stacy Calhoun
    First post 07/01/20,Last post 07/03/20
    Hello everyone, I've built a project schedule and I'm trying to pull only the task that's "In Progress" into the parent row of that phase. So basically my formula needs to look at the children in the status row, find the one that…
    Formulas and Functions2711
    Stacy Calhoun
  • Rigoberto Huizar
    Accepted Answer Rigoberto Huizar 23 views 2 comments Most recent by Rigoberto Huizar
    First post 07/02/20,Last post 07/02/20
    I am having  trouble with my formula.  A portion works but as soon as I insert the IF and ISBLANK Statement it Fails. I want the formula to use the "Actual Plan Actual Finish" column and if that is empty then use the "Action…
    Formulas and Functions232
    Rigoberto Huizar
  • A Rose
    Accepted Answer A Rose 9 views 3 comments Most recent by Paul Newcome
    First post 07/02/20,Last post 07/02/20
    How Can i write the above IF Column [email protected] or Column [email protected] is more than 10, say yes, so smartsheet understands? Anyone, Please assist. Thank you!
    Formulas and Functions93
    A Rose
  • Hunter Gade
    Answered - Pending Review Hunter Gade 17 views 1 comment Most recent by SoS | Dan Palenchar
    First post 07/02/20,Last post 07/02/20
    I have a parent row that represents a task and the children rows vary depending on the number of days to complete the parent task. And so what im trying to figure out is what equation would look for the "last" value or the most c…
    Formulas and Functions171
    Hunter Gade
  • Saramitsu
    Answered - Pending Review Saramitsu 17 views 1 comment Most recent by SoS | Dan Palenchar
    First post 07/02/20,Last post 07/02/20
    Hello all! Is it possible to add an external folder link to your sheet somehow? A clickable link? I.e. a path to a folder in one of my drives. Thank you!
    Formulas and Functions171
    Saramitsu
  • jmoser
    Answered - Pending Review jmoser 15 views 2 comments Most recent by jmoser
    First post 07/02/20,Last post 07/02/20
    Hi - I know this has been asked several times but I cannot seem to get the syntax right on my summary formula. I need to count the total number of agreements that are in the DIVISION REQUESTED BY column with any part of General Counsel the…
    Formulas and Functions152
    jmoser
  • Andy Counsell
    Answered - Pending Review Andy Counsell 10 views 1 comment Most recent by Genevieve P
    First post 07/01/20,Last post 07/02/20
    Hi Relatively new to smartsheet and getting to grips with sum of the hierarchy functions I want a formula that returns the task name for the milestone of any given task. or the task name of the last child any help very much apreciated
    Formulas and Functions101
    Andy Counsell
  • Compte Général
    Answered - Pending Review Compte Général 16 views 1 comment Most recent by Genevieve P
    First post 07/01/20,Last post 07/02/20
    Hi everyone, I'm trying to make a planing scheduel starting from my ending due date. I need it to calculate automaticly my starting date. Can anyone help me?
    Formulas and Functions161
    Compte Général
  • Jennifer Murphy
    Accepted Answer Jennifer Murphy 27 views 3 comments Most recent by Genevieve P
    First post 06/29/20,Last post 07/02/20
    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…
    Formulas and Functions273
    Jennifer Murphy
  • Debra Platt
    Accepted Answer Debra Platt 13 views 14 comments Most recent by Genevieve P
    First post 06/26/20,Last post 07/02/20
    Hello! I have two Smartsheet's which are identical except for links are not consistent between the two...any thoughts on how to identify links that are not on both Smartsheet's? There is no way to filter to linked cells only, or run repo…
    Formulas and Functions1314
    Debra Platt
  • em_sfcc
    Answered - Pending Review em_sfcc 21 views 5 comments Most recent by Paul Newcome
    First post 07/01/20,Last post 07/02/20
    I am doing end of year summary data and am stuck. I ran a report and have lots of data - name, gender, race from rosters across multiple trainings. There is duplicate data (X individual may have attended Y training, but also Z training). I…
    Formulas and Functions215
    em_sfcc
  • Frank Falco
    Answered - Pending Review Frank Falco 145 views 5 comments Most recent by Paul Newcome
    First post 03/16/20,Last post 07/02/20
    I have a sheet that has a column called Steps, Values Step 1, Step 2,...Step 10 From another sheet, I want to count how many Steps happen in a Stage (which contains a number of Steps) I would like a count formula that looks at the Steps in…
    Formulas and Functions1455
    Frank Falco
  • Sharon Castiglia
    Accepted Answer Sharon Castiglia 15 views 5 comments Most recent by Paul Newcome
    First post 07/01/20,Last post 07/02/20
    Hello, I have the following formula that only works if a time is entered hh:mm pm. I can't seem to find a way to get this to accept PM. Only works with pm. =IF(FIND("pm", [Tech Arrival Time]@row) > 0, "P", "A&qu…
    Formulas and Functions155
    Sharon Castiglia
  • Ruth Potts
    Accepted Answer Ruth Potts 16 views 2 comments Most recent by Ruth Potts
    First post 07/02/20,Last post 07/02/20
    Hi, (Image) I have used the formula =IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1) in the flag column to turn the flag red when the end date is passed and completion is less than 100% which is great. BUT.... It now red …
    Formulas and Functions162
    Ruth Potts
  • Krista Cornew
    Answered - Pending Review Krista Cornew 13 views 1 comment Most recent by Jason Tarpinian
    First post 07/02/20,Last post 07/02/20
    Is there a way to automate those columns so they can recognize a pattern? For example. If I create a task that happens every two weeks and schedule the first set of dates, is there a way to automate that, so if I pull the cells down, it ca…
    Formulas and Functions131
    Krista Cornew
  • Marvin Daniels
    Rolling 12-Month GridAccepted Answer
    Accepted Answer Marvin Daniels 19 views 5 comments Most recent by Marvin Daniels
    First post 07/01/20,Last post 07/02/20
    I've built the rolling 12-month grid below, which will be referenced elsewhere in this summary sheet.It works, but this could be cleaner. I know I could remove the "helper" row (row 1), but this is how I worked it out, so I kept …
    Formulas and Functions195
    Marvin Daniels
  • System
    Answered - Pending Review System 12 views 2 comments Most recent by Paul Newcome
    First post 07/02/20,Last post 07/02/20
    This discussion was created from comments split from: Count of cells in a date range.
    Formulas and Functions122
    System
  • HOFF
    Answered - Pending Review HOFF 12 views 3 comments Most recent by Paul Newcome
    First post 06/30/20,Last post 07/02/20
    Keeping track on vacation time I need to convert dates to weeks and then again to an overview with checkboxes. In order to get a list of weeks [c_weeks_listed] (later in use with FIND) I have come up with the following IF-formula which wor…
    Formulas and Functions123
    HOFF
  • Alan Donovan
    Accepted Answer Alan Donovan 23 views 11 comments Most recent by Paul Newcome
    First post 07/01/20,Last post 07/02/20
    I have a multi select dropdown column where users can select phases of a job they have experience in. For this example, let's say they have the options of "Pre-Execution", "Execution", and "Closeout". I want t…
    Formulas and Functions2311
    Alan Donovan