-
Avoid no match until data is populated
I am pulling information i.e. a date, from one spreadsheet over to another spreadsheet. Since the date field may still be empty on the source sheet, the formula displays "no match" on the spreadsheet. Once a date is being added to the source sheet, then the formula displays the date on the other spreadsheet. How can I…
-
Linking Cells within the Same Sheet (Checkboxes, Dropdowns, etc)
Hi there, I'm building an onboarding checklist/tracker where the main items are listed out and due dates set in 30, 60, and 90 day increments, and having a status column mark the progress. Hitting a roadblock with one particular aspect, which is I want to have all of the items that are due within their first 30 days to be…
-
Totals in a Summary Sheet
Hi again. I have created summaries in a Summary Sheet, but I need to create a total based of the totals of some of the fields in the Summary Sheet. What formula do I need for that? I think this is a Sum formula, but how to I indicate the title of the field created in a summary sheet? Thank you
-
If statements
I need to write an IF/Then formula for the following issue: if a date required is greater than a date requested mark status pending, if delivery date is greater than or equal to date requested then mark status delivered I had written it as follows: If(date required>date requested"Pending"),If(date delivered…
-
How do you calculate the amount of time between two dates but also include an IF?
For example, I want to calculate the amount of time between two dates but only specific to a particular column of data. In this case it is the duration for negotiating a Master Agreement with the Agreement type included in a separate column.
-
Count Distinct from multiple criteria?
I have a data set similar to this sample which contains: Primary column with unique names Visited dates column formatted as DATE ClientID column - this has a many to one relationship with the Primary (Sandra and Mike can both work for the same Client) Results of the visit: Yes, Maybe Product discussed I'm trying to get a…
-
Formula needed - if a cell in column A matches that of any other cell in column A
Attempting a superbowl board this year virtually. I am in need of a formula that will tell me if any Cell in column A is an exact match of any other cell in column A - I would like tit to display "DUPLICATE" in another column.
-
Rolling total
Hi, I'm trying to create a total days column based on the following: start date - end date (ie., 10 days) 1/1/21 - 1/10/21 end date changes to new end date based on extension 1 (i.e., 20 days) 1/1/21 - extended to 1/20/21 extensions can happen at least 4 times (columns are TA EXT 1, TA EXT 2, TA EXT 3 (all are date fields)…
-
How to cross reference two columns from one sheet to a data sheet. Counting by two data points.
Hi All, I am trying to count the number of product types (Column A), by Project Manager (Column D) and am always getting incorrect argument or inparseable. I can get the data if I just count the product types, but not when I want to only count product types by PM. I am putting this formula in a separate sheet (formula…
-
Need a formula for counting something on a weekly basis.
From the screenshot below, I need a formula to count the incoming mail based on each week. I want to show the information on a dashboard on a weekly basis which will exclude the weekends. For example here, I have the data for last week of Jan, but when we enter into next week, first week of feb, I want the dashboard to…
