-
Help with returning value from two criteria
I want to fill the empty green field by matching the yellow and blue fields. I've tried Index collect and index match match. =INDEX(COLLECT({QuantityOverview}, {PPEReceiptOverview Range 1}, Name@row, {PPEReceiptOverview Range 2}, [1 Quantity]1, 1)) returns #INCORRECT ARGUMENT SET
-
Percentage Complete roll-up
Can someone tell me why this isn't working? I am unable to edit the percentage cell in the parent row, it says it is dependent on the rows beneath, but it isn't completely working.
-
How do I use CountIF to count items 30 days or less from Today without counting items in the past?
I have a CountIF formula set to count the number of cells that have dates 30 days or less from Today's date using the Today function, however it is also counting dates that are in the past. I only want to count the number of dates that are 30 days or less in the future. Any way I can exclude past dates? Here is what I amโฆ
-
Sumifs for Entry Date & Job Number
I am trying to create a cumulative count of all Piers Completed through a given date respective to a specific job (Job Number) below is the syntax I have so far but my argument is coming back incorrect... =SUMIFS([Job #]:[Job #], [Job #]@row, [Piers Completed]:[Piers Completed], [Entry]:[Entry], <[Entry]@row) Entry = Dateโฆ
-
COUNTIFS Across Different Ranges Returns #INVALID DATA TYPE
Hi Smartsheet Community, I am stumped. I have a COUNTIFS formula that behaves as expected on my test sheet but returns an #INVALID DATA TYPE error when replicated on a actual sheet. The Column Types and formatting are the same on the test sheet and actual sheet. I would like to count the number of instances where Unitโฆ
-
Formula that compares one cell to another
Once again, Iโm coming to this community for help with formulas. Is it possible to create a formula that compares one cell to another cell (in the same sheet), and if they match, Iโd like the word โVERIFIEDโ to automatically appear.ย And, if they donโt match, Iโd like the word, โERRORโ to automatically appear. Iโd like toโฆ
-
Find Latest Date for With a criteria in rows
I have a form that my field team inputs the action they make in customer, the same form is used for every customer, In Another sheet, I have the visit controle, and in this other sheet, I want to know the last visit my team made to each customer. So I need to use a MAX formula for each specific customer. The only solutionโฆ
-
Formula in a dropdown menu
This is what I am trying to do... I need the total of "amount Due" if "invoice" is selected. And the Total of "Amount Due" if "On Order" is selected. I would like for that info to populate at the top Help!
-
CountIf for a Multi-Select List
Good Afternoon, I am building out an executive dashboard to support our SME Team and I am looking to count the number of times a specific value appears in a multi-select column. I am getting Unparsable errors with every attempt, any suggestion would be helpful. This is my formula - =COUNTIFS(SME - Feature Progress Rangeโฆ
-
Opportunities matching hygiene moment
I am trying to create a formula to ensure that the opportunities match with the hand hygiene moment (See below). Hoping to capture this info via submitted form. Is there a formulla I can use to ensure that they match?