-
Filtering a report by Calendar Month and sending report
Hello, I have a report that I would like filtering by calendar month showcasing data just for that month. I can only seem to filter the report by 'last 'x' amount of days'. Seeing as though months vary in days, the report it could show additional data not required. I had then created some helper columns on the underlying…
-
I want my formula to count the blank cells in another sheet and also by a particular status
=COUNTIF(AND(NOT(ISBLANK({My sheet - Unit}),{My sheet - Status}, "New Request")))
-
Vlookup Date into another Date field - #DATE EXPECTED Error
Hello, I am using a VLOOKUP to pull a date into a sheet from another sheet. Both columns (date source / range, and destination column) are Date column types, but the destination sheet is returning the # DATE EXPECTED error. I thought if you were pulling a date from a date column, into another date column, the return value…
-
Improve how logic functions work with contact columns
If a contact (e.g. one in my personal contact lists) has a text field name associated with it, it displays as that name. Then, if wanting to search for that contact in a contact column using the associated email address, it is not found. Please develop a function that returns as text the email address of a contact.…
-
Can I use a formula to copy the date from my "Target Date" column to my "Projected Date" column?
I'm working on creating a project status dashboard to share with stakeholders at my company so they can easily understand where each project stands. I have a "Target Completion Date" column and a "Projected Completion Date" column. I'd like to be able to use a formula so that when the "Status" column says "In Progress, On…
-
How do I count for something that has not already been used in a cell from a multi cell dropdown?
Hi all, I need help! From this list of machines, I would like to know which machines are available on a particular day.. I have a date column on my sheet. How would I solve this? Much appreciated!! Thank you!
-
MAX function -most recent date
I know this should work, but it's not. I am referencing other sheets and pulling in the max date. I am getting an unparseable in return. What am I missing? If I put just one "HOUDATE" it's invalid. yes - I am pulling from Date column types. Thanks!!
-
Adding a date range to COUNTIFS
Hello, I need to add a date range to a rollup I created for tracking sales meetings: =COUNTIFS({source sheet customer name}, $[Primary Column]@row, {source sheet dropdown result}, [In Person Meeting]$1) The above works, but is obviously counting the whole sheet, which includes 2 years of data. I tried: =COUNTIFS({source…
-
Systems columns
Hi, I have a form that gathers data. The team works on it and rows change status. Once a row changes to approved, I'd like to move it off to another sheet but my automation is giving me an error - sheet you are moving data too has a systems column of the same name as your original sheet. I have deleted my created by/date,…
-
IFERROR and INDEX/MATCH formula with criteria?
I am using this formula currently on a work document (slightly modified): =IFERROR(INDEX({Assigned Specialist}, MATCH([Project Name]@row, {Project Title}, 0)), "") Now, what I would like to add is a criteria to this formula that checks the other sheet (the same sheet that Assigned Specialist is on) to see if the Project…
