-
Alert(s) Updating a "Count" Sheet?
I have an end user I am trying to build a records sheet for and I can't figure out how to accomplish a change count cleanly. We have thousands of rows/records in a sheet with one of the fields/columns being a Status.They do a monthly review of how many records moved to different statuses in that month and I want to…
-
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 calculating monthly totals
I am trying to write a formula that will calculate receipt totals by month (starting this month) Here is the formula i am using, but it is returning an invalid data type =SUMIFS({Joseph Nelums- CRS Expense Reporting Receipt Total}, {Joseph Nelums- CRS Expense Reporting Date}, YEAR(@cell) = YEAR(TODAY()), {Joseph Nelums-…
-
Circular Reference Help
I know this is a long shot but here goes. I have 2 sheets: a calculation/capture sheet and a reference date calculation sheet. The first gets information from a web form and does a few on-sheet look-ups and calculations. Two pieces of data are pushed to the second sheet where date calculations occurr and the 3 resulting…
-
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
-
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?
-
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…
-
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…
-
Counts if with multiple conditons
Help! Trying to get a count if line items that do not have a column marked resolved and have a issue type of Reports Missing. =COUNTIFS({Aimbridge Report Issues Range 2}, "Reports Missing",{Aimbridge Report Issues Range 2}, 0) I am sure it is simple...but I an not figuring it out and need help!
-
Countifs using iferror or iserror
Hello, I'm trying to use a COUNTIFS formula to count the number of VLOOKUP errors in another sheet that occur in the past month. From what I can see in other discussions the IFERROR and ISERROR functions are generally used to give a 0 value but I want it to return a value of 1 for each error. This is the formula I've been…