-
How do I stop a time-based reminder once an action has been completed?
Hi, I'm using a Form to pull information about different tasks and using time-triggered reminders for recipients until the task is completed. I want to avoid continued reminders after the task has been completed by using an automation to cancel the reminder, but haven't found a workable solution so far. Any ideas on how to…
-
Return the last value or latest value for a specified product
Hi, I am trying to return the most recent value for any part description Vlookup always gets the first one, any idea on how to 99 from the example below without sorting the data .. as the rows will be added automatically to this sheet from another sheet and they always go to the bottom row Thank you
-
Sumif Formula Question
I have a sheet containing a Time Block column as well as a Type column. Both are dropdown columns one with time in hours (.24, .5, .75, 1, 2 and so on), the other has types of activities (Dev Meeting, General Admin, and so on). I am trying to build a formula that adds the time for each activity by the month. I can't get…
-
INDEX MATCH or JOIN COLLECT formula for multiple criteria's
Hello, I am attempting to take a previous intake from and update the new form will allow for more "automation". On the form the requestor/submitter selects a theater and region/country. Once the intake form is received the data in the sheet populates (based on formulas) the following: division, country, PRM, RPL, or SRM.…
-
Sheet Summary Formula
Hi Team! I'm hoping to get some help on Sheet Summary formulas. As you can see per my screenshot below, we have 2 projects. I'd like to do 2 things on the sheet summary: Be able to filter by project name. Once I filter by project name, I'd like to see see the total amount, the total amount due, and the total paid for that…
-
How to change the year on a date based on a condition
SHORT VERSION: How do I write a formula to pull a date from one column and update JUST the year of that date if a condition is met in a separate column Very Long explanation: I have a data base of contracts that must be evaluated either once a year or every 90 days depending on risk level. The initial evaluation due date…
-
How to cross reference dates on a master sheet and then edit those dates on different worksheet?
Total noob here. I have a master sheet with 4 critical dates in regards to completing a major project (new restaurant opening). The critical dates are subject to change as some parts of the project are subject to be delayed due to construction, permits, etc. I would like to only have to change the dates on the master…
-
Applying a formula when a filter is applied
Hi! I am building a team monthly capacity tracker. Right now, it's all in one sheet and I have filters set up based on the 'Owner' column, so each team member can view and update only their projects and activities. I have a formula summing up team capacity each month at the bottom of the sheet. Is there a way to carry over…
-
Status Change
Good morning community I hope you can help, I just can't seem to get this formula right... I have the following status categories on a color wheel Red - Overdue Yellow - Task Outstanding Blue - Investigation Outstanding Green - Resolved The conditions are as follows: If Scheduled Date column is blank then the Status column…
-
Autogenerate IDs built off of other IDs?
Hello! I'm trying to auto-generate IDs that build off of another ID. The formula I'm currently using is: =[Initial ID]@row + "-R" + COUNTIF([Initial ID]:[Initial ID], [Initial ID]@row) I would ideally have it set to: =[Initial ID]@row + "-R" + COUNTIF([Initial ID]1:[Initial ID]@row, [Initial ID]@row) But that's not allowed…
