-
Help with IF formula using Today formula and unparseable error
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", "Normal")) I want the sheet to check if a task is not yet marked complete (<100 %) AND the current…
-
Formula for counting Stars across multiple sheets
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?
-
If Checkbox is not needed, show blank
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
-
Formula help - adding criteria to LARGE?
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 total hours" column which is a cross-sheet reference SUMIFS formula 3) "Project priority score" column which is a…
-
Formula help counting back 30 days
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, however if a date is in the future it still counts it. =COUNTIFS({Monmouthshire Housing…
-
Finding and returning values in a range of cells
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 certain value, and join them together. For example, say I had a row with 4 columns that say…
-
IF(FIND Function with OR
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) > 0, [Estimated Hours:]4, "") which works great, but add in other words such as Graphics to it. So…
-
Trying to get a sum of specific child rows
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 get how much time each team member is spending in total
-
countifs with a date criteria
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 Proposal date column that is in a MM/DD/YY format. =COUNTIFS({CPI Prospects 2019 Range 1}, "New…
-
COUNTIFS | 2 CRITERIA FROM SAME COLUMN | REFERENCE SHEET
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 sheet. My goal is to count the number of "approved" and "completed" quotations (same column)…
