-
Broken SUMIF Formula - Sum of column based on info in another column
Hello everyone! I am currently attempting a SUMIF equation that initially worked and is now broken. Here are the parameters. I would like the sum of the dollar amount in this column "FY24 Adopted Budget" to show in a cell in this column, "July Expenditure" based on the information in these columns "Cost Center" (Dropdown…
-
Collect most recent date from another sheet based on certain criteria
Hello I have a fleet maintenance log that has invoices per vehicle with a column that is a drop-down with multiple values based on the service provided. I am trying to make a sheet that would be a quick reference to see the most recent service per vehicle per category. Being multiple services will but under a category I…
-
INDEX MATCH is matching same values to everything
Good morning all, I'm having some issues with this INDEX MATCH, that are really stumping me. Here is my formula: =INDEX({NE INVOICES Range 4}, MATCH([PO#]@row, {NE INVOICES Range 1})) And here is what I'm getting: This would normally be fine, as those PO's don't exist on my source (Here is the source sheet) The issue is as…
-
Total of Certain Value Across Multiple Sheets
Hello! Hoping someone here can help. I have 6 sheets that are identical in setup and parent rows (inventory for each vendor - Child rows are only varience being actual inventory). I'm needing a summary sheet that totals the quantity across each of the 6 vendor sheets. I've tried a variety of…
-
1 PDF that requires two signatures, not sure where to start, kindly help?
Hi all! I'm looking for some very basic help to get started as I'm not sure where to. I have a single PDF form that requires two signatures. The first signature should be from an employee, say "x". The second signature then needs to be of that employee's supervisor, say "y". Once both folks sign, that form needs to go to…
-
Automated Drop down or Formula?
Hi all, I was wondering if there is a formula or drop down function that can auto populate words or drop downs? As seen in my conditional formatting for "Days Left Till Expiration it conveys whether if it is red, Yellow, Or Green based on the amount of days passed or upcoming till a Term end date. I'm wondering if I can…
-
Days left on a Term End Date
Hi all, I was wondering if there is a function that conveys how many days are left for renewal license as seen in the image. Obviously the dates listed have been expired & I was wondering if a negative positive function can be conveyed as an example -1,847 in the "Days Left Till Expiration" column
-
How do you exclude a specific dropdown status from another sheet in a formula?
I have 2 sheets. One sheet (Requestors) is tied to a form for people to get information about a possible coach. Through this awesome community, I've been able to figure out how to pull the information I need from the 2nd sheet (Coaches list), and display it in an automated email to the requestor (with a line break between…
-
Upvote Function / Brainstorming Layout
Does anyone have a template or is there a video that shows how to create a sheet that has an "upvote" or "voting" function of any type? Ideally what I'm looking for is a way to have different product ideas listed out and then allow for our team to vote on which items they like the most.
-
New user here... Need formula on how to count how many entries in a column are in a specific month
Hey there, I have wracked my brain for hours trying to find a formula that will allow me to count how many cells contain the month Jan, Feb, etc. So far I have tried the following.. Please let me know how I should adjust: =COUNTIFS({[ Range 1]}, @cell >= DATE(2024, 1, 1), {Certificate of Destruction Range 1}), @cell…
