-
COUNTIFS Formula Assistance - How to count date ranges
I am trying to create a COUNTIFS formula that has 4 ranges/criterions that pull references from another sheet. Below is the current formula. It was working right prior to adding the date ranges but I cannot figure out what is going wrong. The formula still works and pulls in 0 but that is not accurate, it should be coming…
-
Equation to populate new number
Hello. I have a sheet with 4 columns: one is the name of the material (Material Name), the next is the quantity of that material that we have in stock (Quantity), the next one is who claimed this material (Claimed By), and then the last column is how much quantity that person claimed (Quantity Claimed). So for example, if…
-
How to record monthly changes in sheet?
So I am trying to get a formula to return a count of the number of cells that match but only if another column that records a date is within the last 30 days. I tried with reports but the issue is they don't display right if I try to send updates in any way besides a link (and I need it to run monthly, weekly, etc.) I felt…
-
Automatically Send Responses on Form
Hi, I have a Form that a variety of Managers use to input data. Is there a way to automatically send their responses on the Form to them after? Or do they constantly have to check the "send me a copy of responses" button each time they submit something? I tried to setup an automation for it, but I am not sure how I would…
-
Index formulas replacing VLookUp Formulas
Hello It has been recommended that I replace my vlookup formulas with Index(Collect) formulas. This is my first experience with the Index and / or Collect Match concept and honestly I am struggling on my first try. I am trying to pull in a total funds approved value from the my budget sheet to my portfolio sheet. Both…
-
ISBlank question
I am trying to return a 0 if my date is blank, if not I want to return a 1 if the date is greater to another date or return a 2 if the date is less than or equal to the other date. here is the formula I am trying to use =IF(ISBLANK([Due date]@row, 0, IF([Due date]@row > date@row, 1, IF([Due date]@row <= date@row, 2))))
-
If any field is blank, highlight that cell only
I have a formula that returns a "Red" symbol if any of a number of fields is blank, otherwise the symbol is "Green". =IF(AND([Column1]@row <> "", [Column2]@row <> "", [Column3]@row <> "",[Column4]@row <> "",[Column5]@row <> ""), "Green", "Red") Is there a way to have any blank fields then highlighted a different color?…
-
If any field is blank, symbol should be red
I'm trying to figure out how to write formula where, if any one of multiple fields is blank, the symbol is red, and if no fields are blank, symbol is green. Thanks!
-
How to remove the 2 apostrophe while scannig the barcode
Hi All, I hope all are doing great I just wanted to check how I can remove the 2 apostrophes from my cell value as I scanned the barcode and I got this value ''0987654321. As I used the VALUE formula but it is not working for apostrophes. Thanks for the help!
-
Extract Series of Occurrences of Strings into Separate Columns
Hi @Paul Newcome , You mentioned in another thread here: https://community.smartsheet.com/discussion/63606/extracting-string-from-a-cell? "If you wanted to parse them out across individual columns, we would instead use a series of LEFT/FIND and MID/FIND statements." The previous thread looked to me like someone was using…