-
Report to show last data entry only
Good morning, I am looking for a report to return a column value from the last sheet data entry. Essentially, I would like to create a dashboard that tells me whether my machine is online or offline based on the data that the operator puts into the highlighted column. I'm guessing that generating a report would be the best…
-
If function with dates
Hi Experts, I'm trying to create a formula which should give me a Date as result. I have 2 check boxes and depends what it's clicked I would like to get the date below as results. If HALO Calendar is not clicked than DATE DATE(2022 / 8 / 26) IF HALO Calendar and Virtual Model CR1 is clicked than DATE(2022 / 10 / 13) If…
-
IF AND Formula Help
Hi everyone! I am hoping you can please help me. I have tried IF AND, IF OR, and IF CONTAINS formulas but nothing works. Referencing the below screenshot, I have a checkbox in the column titled "Carry Forward". I want to have the check box checked when the column titled "Vacancy Status" contains either the word "Assigned"…
-
Formula for Modified Date
Hello, I want to keep track of End Date changes on workstream plans. Aware the automated Modified Date column is updated following any change to that row. I want to find a way to populate a Changes Log with specific information from a row, if the End Date Column has been updated. Unfortunately, the layout of the activity…
-
Build Report that shows "Child" lines items under the "Parent
I am trying to build a report from a sheet that has a parent line item with child line items. I need the report to show the parent and the child. Then have the ability to group by the parent. When the parent is expanded it shows the children. My report currently looks like this...all the indented child line items are no…
-
I need help with a SUMIFS formula to calculate total hours for an assignee based on dates
I'm working with a sheet that has a start date and due date, a column for assignee name, and a column for Hours/Week they're working on a project. I'm trying to get a formula to calculate the total hours an assignee is working throughout the sheet between two dates. I'm currently trying the formula below but it's brining…
-
Tracking Previous Week Order Completions vs This Week
Hello, This feels like a simple question, but the answer is eluding me. We have dates getting automatically logged for when orders come in/are delivered, and then another automation to log the date when the inspection is completed. I need to have two different results. One for when an order delivered from the previous week…
-
COUNTIFs Help.
Hello, I am trying to count how many times the names appear in the "Career Counselor" column, these are just a few examples, we have a few hundred different names and thought a formula would be easier. I have tried different formulas combinations using "COUNTIFs" without any success, please help. Thank you!…
-
Find next milestone in project plan
I have a project plan in which I want to write a formula to retrieve the next milestone, a task with a duration of zero, from a list of tasks. Task Name = Text/Number column Duration = Duration type column Start = Date column I have this formula which returns the first milestone in the Task Name list. The first task with a…
-
COUNTIFS date range less than 90 days from date in cell
Hey all, I can't find anything on this and struggling to come up with a formula looking at last 90 days from a set date. Please see attached screenshot for my current formula but I feel it shouldn't be this difficult and is probably something easy but currently stuck. My formula is not working because I have dates in the…