-
I need help with a formula to determine the number of days a certain criteria has appear in a table.
I am new to smartsheet and trying to help our quality team. I need a formula that will count the number of unique days that an auditor has entered audits. I have one sheet that is the complete database with an automatically created date for every audit and another row that list which auditor created the entry. In another…
-
SUMIFS Formula Reference Another Sheet
I have a budget sheet that I want to pull total monthly expenses from another sheet. The below formula is calculating the total [Health & Safety] spend, but I want it to only calculate expenses for June. I have another column which picks up the month from the date column. I am wondering if it is a SUMIFS formula and I need…
-
#Invalid Data Type - multi drop down
I have a cross sheet formula and data is counting with the exception of value 1. The Intake Sheet Range 1 with "Formal Quote" has multi select dropdown. =COUNTIFS({Intake Number of touches}, Days@row, {Lead-Time exempt}, =0, {Intake Sheet Range 1}, ="Formal Quote", {Intake Sheet Range 2}, IFERROR(MONTH(@cell) = 4, 0))
-
Additional Criteria - SUMIFS
Hi Everyone, We are achieving to create a new adjustment in our visualization that will allow us to automatically calculate the total numbers of FTE per month drilled down to Status. Needing someone to correct my formula as it returns an error on my end. Formula 1 for In Progress SUMIFS({FTE}, {DateReceived},…
-
How to create formulas when multiple rules are involved?
Hi I am trying to build the following: There are 5 criteria that will indicate the Project Health Status. The Health Status will be base on the following rules: 1) Green: 4 indicators or more in “Green”, none in “RED”. 2) Yellow: None in “Red”, with less than 4 indicators in "Green". 3) Red: One or more indicators are in…
-
SUMIFS not in the same sheet
Hi All I am having a tricky time with a SUMIFS formula that is not in the same table as the data. I can get it to work within the sheet; =SUMIFS([Total Recommendations]1:[Total Recommendations]45, [Allocated Senior Auditor]1:[Allocated Senior Auditor]45, "Auditor Name", [Senior Status Complete]1:[Senior Status Complete]45,…
-
COUNTIF Exclude
I'm trying to exclude a column that has item checked with a checkbox from a result, but I'm getting an UNPARSEABLE error. It works fine until I add ", NOT..." Any guidance would be appreciated. =COUNTIF({Resource Request with Range 2}, [Primary Column]@row), NOT({Resource Request with Range 3} = "is unchecked")
-
Bid Sheet
I was able to set up a bid sheet, where vendors of mine are able to add pricing to a list of items and have that information flow over to a master sheet. The problem is I need to do this each week. Is there a way to archive the previous files and start with a blank template automatically each week?
-
Need Help with an INDEX(Match) formula
Hello, I need some help sorting out an INDEX(match) formula that is not working despite my best efforts. It may be that I have been staring at it too long. I keep getting a No Match when I add "0" in search type, and I get the first value in my column when I add a "1" in search type. It seems ot be returning the first…
-
Updating Existing Formula: Counting Metrics
Hello! I am working on a formula that I had once before that is not working when I transfer it to a new sheet and update the names of the rows that I wanted to add. Prior Formula: =SUMIFS(CHILDREN(), CHILDREN([Recruiter Name]@row), AND(@cell <> "Full Time >0.5", @cell + ROUNDDOWN(SUMIF(CHILDREN([Recruiter Name]@row), "Part…