My question is this I am struggling to understand what function I need to use so that it returns the most recent value I have added in the column. I want to know how to make the VLOOKUP function retur…
Hi , I have fleet of cars my drivers manually on daily basis type the KM/Millage reading in Column (Km/Today) I need formulla for column Alert as follows: - - - - - - - - - - - - - - - - - - -- - - - …
I have a COUNTIFS formula that I use in a roll-up sheet to count the number of tasks specific individuals have assigned to them on a Project Task Sheet. The values from the roll-up sheet are fed to a …
Sheet 1 has a column "Date Conducted". Another column "Status" with dropdown options "Safe" and "Improve" Summary Sheet has two columns, "Start Date" and "End Date". On the summary sheet, I'm trying t…
Is it possible to put a link to the source sheet that a row was copied from in the copied to sheet with a formula so it adds the source each time? Sort of like a report will give the source sheet. I'm…
Sometimes there are two approvers, sometimes only one. If there is only one and they "Confirm", I record a date column otherwise not and my workflow runs. Sometimes there are two, if they both need to…
Hi I'm in the process of creating MTD and Previous MTD helper columns. If the Create Date is current month, I want to check a box. I have this formula working perfectly. What I'm struggling with is pr…
Hi - I am trying to create a formula that shows the conditions of: Tasks due within the next 14 days that are not equal to the status of "Complete" or "not Required" I am looking to do this on as a su…
Hello! I am trying to count the number of unique customers from one column, that have been flagged with the year 2022 which is recorded in a separate column. Formula I have is - =COUNTIFS(DISTINCT({Cu…
Hello, I created this formula: =COUNTIFS(CONTAINS("2009", {Protocol #}), {Amendment}, "0") To review a list of Protocol Numbers (column) that contain 2009 (the year, part of the protocol number) and a…
