Formulas and Functions

Discussion List

• Help with IF formula using Today formula and unparseable error

  In Formulas and Functions

  I have entered the following formula into a text/number column and I'm getting an unparseable error. I have checked the that column headers are spelled correctly.  =IF(AND([% Complete]2 < 1, TODAY() >[Finish]2), "At Risk",…

  UWSOM-EQI

  05/01/19

  114 3

  114 views 3 comments 0 points Most recent by Shaine Greenwood 05/01/19Formulas and Functions
• Formula for counting Stars across multiple sheets

  In Formulas and Functions

  I am trying to count the Stars that are checked across multiple sheets.  I can’t seem to get a formula to work.  Would anyone know?

  Jessica.Kelly53216

  04/30/19

  21 1

  21 views 1 comment 0 points Most recent by sean59916 04/30/19Formulas and Functions
• If Checkbox is not needed, show blank

  In Formulas and Functions

  Hello Smartsheet Gurus, I have a spreadsheet that has a few columns as checkboxes, but when the checkbox is not needed, I want the cell to show nothing.  Is there a way to do that? Thanks, Arryn 

  APotter

  05/08/19

  1 5

  1 view 5 comments 0 points Most recent by Andrée Starå 05/08/19Formulas and Functions
• Formula help - adding criteria to LARGE?

  In Formulas and Functions

  Seeking some advice on how to make the LARGE function play nice with criteria and possibly, I'm thinking, the COLLECT function.  Here's our set up: "Master project sheet" with: 1) "Project name" column 2) "2019…

  Jaye Casciano

  05/03/19

  168 5

  168 views 5 comments 0 points Most recent by Paul Newcome 05/03/19Formulas and Functions
• Formula help counting back 30 days

  In Formulas and Functions

  Hi I am trying to create a formula that count all entries by a certain person within the last 30 days. This is a cross sheet formula and seems to work well. Now comes the however! I have the below formula which does the calculation, howe…

  dave.mcpherson56751

  04/30/19

  66 5

  66 views 5 comments 0 points Most recent by Nic Larsen 04/30/19Formulas and Functions
• Finding and returning values in a range of cells

  In Formulas and Functions

  Hi all, I'm having a lot of trouble joining cells that contain a certain value (because there is no contain function).  I have a range of cells that are all in a single row, and I'm trying to collect all of the cells that contain a certai…

  erober01

  05/02/19

  960 5

  960 views 5 comments 0 points Most recent by Paul Newcome 05/02/19Formulas and Functions
• IF(FIND Function with OR

  In Formulas and Functions

  I am trying to build a formula that searches in a column for a certain word using the IF(FIND formula but I would like to add in an OR to that. So I would like to use this function: =IF(FIND("Design", [Project Description]4) >…

  BTMarketingOps

  05/02/19

  677 5

  677 views 5 comments 0 points Most recent by Paul Newcome 05/02/19Formulas and Functions
• Trying to get a sum of specific child rows

  In Formulas and Functions

  Hello, My team is tracking hours spent on assigned tasks. We have our SpartSheet set up with: Parent Row : Date, and Total Hours spent for Child Rows Child Row: Team Member, and Hours spent   I am looking to see if its possible to ge…

  Elie

  05/01/19

  1 3

  1 view 3 comments 0 points Most recent by Andrée Starå 05/01/19Formulas and Functions
• countifs with a date criteria

  In Formulas and Functions

  I am trying to create a countifs formula that would count "New Quotes" with a  January date while it's referencing another sheet. New Quotes would be in  the New Quote/Repricing column of this spreadsheet and then there's the Pr…

  drodgers

  04/30/19

  45 4

  45 views 4 comments 0 points Most recent by Paul Newcome 04/30/19Formulas and Functions
• COUNTIFS | 2 CRITERIA FROM SAME COLUMN | REFERENCE SHEET

  In Formulas and Functions

  Kind Sir/Madam,  Greatly appreciate any help on the following: I created an extra sheet with formula's so I can have them displayed in a dashboard without having to add all kind of formulas and outcome of these formulas in my source …

  MikeChap

  04/29/19

  11 6

  11 views 6 comments 0 points Most recent by Nic Larsen 04/29/19Formulas and Functions