-
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…
-
Formula help for my dashboard
Hi all I have a sheet that I use to track recruitment activities within our team. Each role is assigned to a member of the team and has a recruitment status attached to it. I am trying to pull this information into my dashboard to show how many active roles each team member has on the go. However, I only want to select…
-
Budget Sheet YTD Sum formula help
I'm building a sheet for a department who wants to track monthly revenue/expenses and have those numbers roll into YTD columns. (moving them into Smartsheets and out of Excel) Each month has 2 columns Actual & Budget, i want to set up a formula so when numbers are entered into respective monthly cells the YTD cell…
-
COUNTIFS to count when a cell contains any version of a word I want to count
How do I indicate that I would like to count any time the cell has "DESIGN" in it whether the cell says exactly "DESIGN" or "re-DESIGN"?