Formulas and Functions
Archives for April 2019
Discussion List
-
Help with IF formula using Today formula and unparseable errorIn Formulas and FunctionsI 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",…
-
Formula for counting Stars across multiple sheetsIn Formulas and FunctionsI 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?
-
If Checkbox is not needed, show blankIn Formulas and FunctionsHello 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
-
Formula help - adding criteria to LARGE?In Formulas and FunctionsSeeking 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…
-
Formula help counting back 30 daysIn Formulas and FunctionsHi 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…
-
Finding and returning values in a range of cellsIn Formulas and FunctionsHi 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…
-
IF(FIND Function with ORIn Formulas and FunctionsI 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) >…
-
Trying to get a sum of specific child rowsIn Formulas and FunctionsHello, 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…
-
countifs with a date criteriaIn Formulas and FunctionsI 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…
-
COUNTIFS | 2 CRITERIA FROM SAME COLUMN | REFERENCE SHEETIn Formulas and FunctionsKind 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 …