-
COUNTIF Returning "0"
Hi, I have two sheets, "Tracking" and "Summary". In the "Tracking" sheet, I have a column called Fiscal Year. This is a calculated column based on the date entered in the "Date of Incident" row. It works correctly, returns values of "2022" or "2023". Here is the formula: =IF(AND([Date of Incident]@row >= DATE(2022, 2, 1),…
-
Auto-numbering automation
Hello I have a sheet, that uses numerical ranks to keep track of projects. These ranks are simple number assignments (i.e: 1, 1.1, 1.2, 2, etc.), that we use to determine the priority of the project. If a project changes priority, or we have a new project that comes in at a high priority we have to manually update the…
-
Index formula versus If And
Hi, First time posting. I have several sheets I link together. Long story short is web applications pasted into one sheet populate into another for vetting for eligibility of employment. That sheet will then provide the data for my drop downs into the Active Sheet which will pull the corresponding rows of data based on the…
-
Index Match formula work around for Dynamic View
Hello, I am trying to find a solution for a sheet that has multiple lines with the same store#'s and inventory on multiple rows. This is not a shared sheet to our group, so I want to be able to index match this information to another sheet so we can use the info for internal purposes. I dont have the knowledge of how to…
-
I am needing help!
I have a sheet, separate from my form data sheet, with all my users information. I want my form to have a drop down that will display the list of users from the spreadsheet so they can select their name when completing the form. Help! How do I set this up in a form?
-
Project Management Plan - Schedule Health Formula
Hello, I looking to apply a formula to my Project Management plan whereby a color is assigned to each row given the "% Complete" and the "Start Date" "Finish Date". I want the health of the children rows to roll up into the Health of the parent row. I've used one of the templates with a built-in formula, however it does…
-
Converting Calendar Month to Fiscal Month
Hi there, Trying to figure out the best way to report out fiscal month from calendar month. For example, calendar month 7 (July) would need to be Fiscal Month 1. Really appreciate any help. Thank you. -Dan
-
Pull latest date of a task from a Task Sheet to a Latest Contacted Sheet
Hi community! I'm trying to find a way to have two sheets linked together. 1st Sheet: "Task Dump" where I can input the day-to-day tasks & notes after chatting with customers. Columns: Customer Name | Date | Type of Task | Action Items | Addtl. Notes 2nd Sheet: Pulls in the latest contacted date, type of task, action…
-
Due this week formula
I am using this formula =IF(WEEKNUMBER([End Date]@row) = WEEKNUMBER(TODAY()), "This week", "-") to pull a report if a task is due this week. The formula is pulling tasks that were completed a year ago and pulling them into the report as due this week. How do I correct this?
-
Formula to count how many interviews are within the last 7 days and are this week?
I am try to find the right formula to count how many interviews are within the last 7 days but also count anything happening in the next 7 days. The formula I used for the last 7 days is: =COUNTIFS([Interview Date]:[Interview Date], @cell <= TODAY(), [Interview Date]:[Interview Date], @cell > TODAY(-7))