-
INDEX COLLECT MIN (again)
Had a follow up question to my previous question located here. — I was using the original sheets, which I fixed with the solution from that thread, as a template. Today, I copied them over to essentially create the same system for a different LOB. I checked the box that updated all formulas to the new references. Now, in…
-
How do I check an entire column for a particular value and only display the lowest example of it?
The question title is kind of confusing, so here's what I'm looking to find out. I'm making a Project Plan sheet, and want to have a place that updates the estimated completion date based on how the project has progressed thus far. There are more columns in my sheet, but my question is only related to the ones in the…
-
Sort a Join/Collect formula?
In a sheet, I have a helper column that concatenates the date and budget columns. Then a field in the sheet summary that uses JOIN COLLECT to list that data. Is there a way that I can have that listed data be sorted by date? In case this helps, here are some screen shots - Helper column Output of the Join - collect formula…
-
Lookup Formula Not working
I am attempting to do a lookup of a a Date (on the Deliverable Tracker, shown in screenshot #1). The lookup will use the Effective Start and End dates to find the appropriate range, then the end result will be the text value column at the far right. My formula shows a blank result, here is the formula:…
-
Modified Date in Formulas
I am trying to use the auto-populated system column "Modified" in formulas. Specifically, I am trying to create a "Modified Helper" column that takes the "Modified" column date alongside the time, checks if it is after midnight, checks which shift it was logged under, and log the auto-populated "Modified" date to reflect…
-
Formula Help
I'm looking for a formula in column D belw that does the following: Subracts column A from column B, unless column C has an amount. If it does, then I need column A subracted by column C. Row 1 should be -2 Row 3 should be -5 Is this possible?
-
Auto Populate 10 rows with todays date each day
Is there a way to automatically add today's date to 15 new rows each day without deleting previous dates? This would let us track pull the 15 daily task items that need to be completed each day.
-
Contact Type Column automatically populating with Email
Hi all, Is there a way to automatically populate a contact type column with the name and email address if you have the 2 columns with name and email address? Thank you!
-
VLookup returns nothing for assigned to requiring multiple answers
Hi All, I am working on a project plan where I have a drop down that I can select multiple roles to assign a task to. The Vlookup references a contact list of single role, single assigned to. When using a simple vlookup formula, it will give a single answer where there is a single assigned to, but what do I do to make it…
-
CountIfs Formula that Counts Multiple Columns, each with Multiple Values in Each Cell
Could someone please help me correct the following formula?: Formula Goal: COUNTIFS formula that reviews over 10+ columns, each cell can contain multiple values ("Allow multiple values per cell" designation) — What is a formula to count a specific combination? My Example Formula (that doesn't seem to work):…