Formulas and Functions

Formulas and Functions

Discussion List

  • Yashwant Singh
    Answered Yashwant Singh 9 views 1 comment Most recent by Paul Newcome
    First post 03/17/20,Last post 03/17/20
    Whether it is possible to assign a sign off by responsibility to more than 1 person, and either of persons can provide sign off?
    Formulas and Functions91
    Yashwant Singh
  • Laurie Bearden
    Accepted Answer Laurie Bearden 30 views 5 comments Most recent by Paul Newcome
    First post 03/13/20,Last post 03/17/20
    Good morning/afternoon. I have been searching in the help articles and community for an answer to my question, to no avail. I have tried a few different suggestions but nothing has worked so far. Here is my dilemma. I have a sheet that…
    Formulas and Functions305
    Laurie Bearden
  • Jennifer Levey
    SUMIFS on columnsAnswered Question
    Answered Jennifer Levey 13 views 4 comments Most recent by Paul Newcome
    First post 03/16/20,Last post 03/17/20
    I'm looking to sum the values in the duration column, if the row is not marked as a bug (this is a checkbox column) and if the district name matches a value (in this case Muskogee). This is what I've come up with and it's not working: =SU…
    Formulas and Functions134
    Jennifer Levey
  • TeeM
    Accepted Answer TeeM 36 views 9 comments Most recent by Paul Newcome
    First post 03/12/20,Last post 03/17/20
    I need to report on the number of items that appear in the current month to date. Is there a formula that can be applied without necessitating manual entry of changing the month manually?
    Formulas and Functions369
    TeeM
  • TeeM
    Answered TeeM 21 views 5 comments Most recent by Paul Newcome
    First post 03/16/20,Last post 03/17/20
    What is wrong with my Workflow? When the % Complete column changes to 100%, I want the row to move to another selected sheet but it is not happening. https://us.v-cdn.net/6031209/uploads/440/QTEA0M43OEDG.jpg
    Formulas and Functions215
    TeeM
  • Caitlin Bowman
    Answered Caitlin Bowman 15 views 4 comments Most recent by Andrée Starå
    First post 03/16/20,Last post 03/17/20
    Hi there, I've been reviewing past topics but haven't been able to get those formulas to work. I have a sheet where there are start/end dates, and a completed check box column. I'm having trouble figuring out how to create a formula where …
    Formulas and Functions154
    Caitlin Bowman
  • Sue Crawford (admin)
    Answered Sue Crawford (admin) 28 views 6 comments Most recent by Andrée Starå
    First post 02/17/20,Last post 03/16/20
    My =IF([email protected]="Name1", "Parent1") and it worked to bring the Parent name into the @row, but I am trying to also add a few other Child/Parent combos into it as well. For example, In the Parent Column, I want to combin…
    Formulas and Functions286
    Sue Crawford (admin)
  • Frank Falco
    Answered Frank Falco 35 views 3 comments Most recent by Paul Newcome
    First post 03/16/20,Last post 03/16/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 Functions353
    Frank Falco
  • Melissa Kosiewicz
    Accepted Answer Melissa Kosiewicz 30 views 4 comments Most recent by Genevieve P
    First post 03/12/20,Last post 03/16/20
    I need to tweak the following formula to use a [Status Date] instead of "Today". We publish status reports each Wednesday as of Friday of the previous week. I have added a Status Date column that I will update each week to refl…
    Formulas and Functions304
    Melissa Kosiewicz
  • Vyanessa Stephan
    Date formula helpAnswered Question
    Answered Vyanessa Stephan 25 views 3 comments Most recent by Genevieve P
    First post 03/12/20,Last post 03/16/20
    Hello, I'm looking for a formula to pull a date that is 90 days earlier than our start date but on the closest Tuesday. Thank you
    Formulas and Functions253
    Vyanessa Stephan
  • Adam Boyle
    Accepted Answer Adam Boyle 22 views 3 comments Most recent by Paul Newcome
    First post 03/13/20,Last post 03/16/20
    I'm not quite sure how to ask this, but I have cell that has a list of teams you can select from. You can select one team, or have multiple teams selected. If multiple teams are selected then the line item (task) is excluded from the coun…
    Formulas and Functions223
    Adam Boyle
  • Mahshad Farmanbar
    IF Statement - CheckboxesAccepted Answer
    Accepted Answer Mahshad Farmanbar 16 views 4 comments Most recent by Frank Falco
    First post 03/16/20,Last post 03/16/20
    Hi there, I currently have this formula (below) for my checkboxes that states if the end date is less than 30 days away and the Status of a project is "In Progress" the checkbox is checked off. Currently, if the End Date field i…
    Formulas and Functions164
    Mahshad Farmanbar
  • steve50951
    steve50951 23 views 10 comments Most recent by Paul Newcome
    First post 02/26/19,Last post 03/16/20
    I created a form. new entries are entered at the bottom of the form. I copied all of my formulas to the bottom of the form. When new entries come in from the form, they come in below the last row where formulas are copied. Result...formula…
    Formulas and Functions2310
    steve50951
  • Amy Arnold
    Answered Amy Arnold 25 views 4 comments Most recent by Paul Newcome
    First post 03/15/20,Last post 03/16/20
    Hi, I want to pull the SEVEN MOST CURRENT ENTRIES for each QUESTION for each LOCATION. Here's my Master Smartsheet. https://us.v-cdn.net/6031209/uploads/745/RJB22XU6CD5F.png This is the formula I started using based on responses in the c…
    Formulas and Functions254
    Amy Arnold
  • Frank Falco
    Accepted Answer Frank Falco 120 views 10 comments Most recent by Frank Falco
    First post 01/14/20,Last post 03/16/20
    I have the following three columns Idx, Stage and Steps. Steps is a Dropdown Multi-Select column. I want to use the step value from column in another sheet to find which row that step belongs to so I can return the Idx or Stage values from…
    Formulas and Functions12010
    Frank Falco
  • Shelby Simonsen
    Answered Shelby Simonsen 17 views 1 comment Most recent by Andrée Starå
    First post 03/13/20,Last post 03/15/20
    I have a sheet that our PMs approve invoices and another sheet that copies the rows as soon as they are approved. One column is Date Created (Created Date) and the other is Approved Date (Modified Date). When the row is pulled, it captures…
    Formulas and Functions171
    Shelby Simonsen
  • Juan-JLC
    Force upper case on a columnAnswered Question
    Answered Juan-JLC 30 views 5 comments Most recent by Andrée Starå
    First post 02/28/20,Last post 03/15/20
    Hello Everyone, I got a question. Is there any way to force upper case on a text column? I have a column where users enter information using iPads and it will be very helpful if the cells will automatically force to have upper case font i…
    Formulas and Functions305
    Juan-JLC
  • Xander Brennan
    Answered Xander Brennan 24 views 3 comments Most recent by Andrée Starå
    First post 03/04/20,Last post 03/15/20
    I have a sheet that bring in once a week that has our available units and extra data. I need a report to look a this data and return a count of how many units per building are available. Data coming in: Building | Unit Number | Rent Ready …
    Formulas and Functions243
    Xander Brennan
  • Deborah Kardash
    Answered Deborah Kardash 31 views 6 comments Most recent by Andrée Starå
    First post 02/11/20,Last post 03/15/20
    In Excel I can use the SUMIF formula to calculate data from one spreadsheet and show the sum in another Excel file. Excel Formula =SUMIF('2020 Data'!B:B,A5,' 2020 Data'!F:F) - Column B has Supplier List and Column F has all the amounts …
    Formulas and Functions316
    Deborah Kardash
  • MCorbin
    Answered MCorbin 39 views 8 comments Most recent by Andrée Starå
    First post 03/11/20,Last post 03/15/20
    I'm trying to create a PO #. They want to include the date and a sequential number in the PO #, e.g. 2020031100005 2020031100006 I can use the "Auto-Number" function, BUT... they want the number to reset back to 1 for the next …
    Formulas and Functions398
    MCorbin
  • RPIArchShop
    Answered RPIArchShop 38 views 6 comments Most recent by Andrée Starå
    First post 02/27/20,Last post 03/15/20
    Good Afternoon Smartsheet wizards, While I am relatively new to Smartsheet and have purchased some of the learning, the Conditional Formatting is entertaining. I'd like to prove that certain cells have formulas, or not. Thank you in advan…
    Formulas and Functions386
    RPIArchShop
  • Dedrick Tai
    Answered Dedrick Tai 48 views 4 comments Most recent by Genevieve P
    First post 01/22/20,Last post 03/15/20
    Hello, Looking for formula help. I have a master Smartsheet with email addresses and a second Smartsheet with a form that will populate with email addresses entered by the user, so they may not be entered 100% correctly (fuzzy lookup?). I…
    Formulas and Functions484
    Dedrick Tai
  • Lisa Matthews
    Accepted Answer Lisa Matthews 33 views 3 comments Most recent by Genevieve P
    First post 03/11/20,Last post 03/15/20
    HELP!!! I am trying to populate my Status field, using RYG formatting (using the % Complete and Finish Date). The cell displays #UNPARSEABLE. I am not sure what I am doing wrong. I have been reading through the comments in the community an…
    Formulas and Functions333
    Lisa Matthews
  • Billy-Rock
    Answered Billy-Rock 29 views 4 comments Most recent by Andrée Starå
    First post 03/12/20,Last post 03/14/20
    I am trying to have a box checked if a text matches in a certain column. To do that here is the formula I am using in the "Key Claim?" column which is a checkbox column: =IF([Type of Claim]@row = OR([Key Claim Dealer Codes]1:[Key…
    Formulas and Functions294
    Billy-Rock
  • Mel Plummer
    Accepted Answer Mel Plummer 21 views 5 comments Most recent by Andrée Starå
    First post 03/13/20,Last post 03/14/20
    Hi. I am trying to create a formula which uses another formula but keep getting an error message. It works if I use the add (+) symbol but returns an error message when I try to times (*) the cells, i.e. the cost total needs to show the ho…
    Formulas and Functions215
    Mel Plummer
  • Mike Rini
    GroupingAnswered Question
    Answered Mike Rini 16 views 5 comments Most recent by Andrée Starå
    First post 03/13/20,Last post 03/14/20
    We use SmartSheets to manage our display campaigns. With each of our campaigns, we can have 1 to N different pieces of creative associated with them. I'm looking for a way to group (either by ID, Campaign, etc.) my sheet to show the campa…
    Formulas and Functions165
    Mike Rini
  • tcanelli41471
    need help with formulaAnswered Question
    Answered tcanelli41471 15 views 3 comments Most recent by Andrée Starå
    First post 03/13/20,Last post 03/14/20
    I am trying to create a RYG formula Have a drop down column with the choices: 75% staffing 50% staffing 25% staffing <25% staffing I want to say that IF([Staffing Level Impact to MEF]@row = "75% staffing", "Green"…
    Formulas and Functions153
    tcanelli41471
  • Etienne Portelance
    Etienne Portelance 20 views 2 comments Most recent by Andrée Starå
    First post 03/13/20,Last post 03/14/20
    I really like the GPS location that seems to be enabled in the Asset Location template for example. I have about 1000 locations for street furniture we want to upgrade. So we already have the locations in an Excel sheet. How could we trans…
    Formulas and Functions202
    Etienne Portelance
  • MJLaughlin
    COUNTIFSAccepted Answer
    Accepted Answer MJLaughlin 27 views 3 comments Most recent by Andrée Starå
    First post 03/13/20,Last post 03/14/20
    I am trying to create a COUNTIFs for a metric that I need for COVID-19 tracking. I have a datasheet: LOB, and Record Type LOB is a drop down Record type is a drop down either travel or isolation I want to be able to pair up LOB and the # …
    Formulas and Functions273
    MJLaughlin
  • Jturton
    Nested IF AND ORAnswered Question
    Answered Jturton 23 views 1 comment Most recent by Sean Morgan
    First post 03/12/20,Last post 03/14/20
    I am trying to get a formula for a check box that combines an if AND with an If OR. I have a column labeled Rental Billed that is a check box. There is another column that has multiple status options from a drop down. I want the formula…
    Formulas and Functions231
    Jturton