-
Pull data from One Sheet into another based upon criteria
I have one sheet that has address information for employees. I am creating another sheet where I would like to pull in the address of the employee based upon the name that is entered within a specific cell. For example: in Sheet 2 you see Name Test and below I would like to pull from Sheet 1 that specific address for the…
-
Can I Prevent Sorting of a Sheet
I have a sheet that I do NOT want anyone to be able to sort. However, they do need to add content and comments (edit) to the sheet. Is there a way to do this? If there isn't and the editors will be able to do this then I have another question. How can I post or pin something to the top of sheet to let people know not to…
-
Change formatting based on new date input
Background Currently, I am tracking whether a person attended a visit on a certain date and color coding for easy reference. Each row represents a person These dates are at regular intervals, so I'm using a column formula to calculate what the dates should with each each column referencing the column before it as long as…
-
Last Modified data in Sheet Summary?
I'd like to be able to create a sheet summary report for all of the sheets in a workspace, showing their last modified dates. This is to help me gauge when a workspace is no longer needed or to keep an eye on updates at a high level without going into multiple sheets. My idea was to add "modified date" into the sheet…
-
Auto Populating Columns
Hello, I populated the Risk Columns and Task Health Column in this example manually. Is there a way to accomplish this automatically based on the Internal/External Column, Due Date and Status Columns? Additionally, is there a way to remove the Risk flags from the header row in green? For instance: If I select "Complete" in…
-
Best method for linking 2 sets of data together that use forms to collate the information?
I'm working on a project to help devise a solution to track all of our organisation's skills & talent initiatives, plus that will provide us with some useful metrics. The plan is have 2 forms - part 1 that collates all of the schemes' information and then a part 2 that collates information on outputs, but which is sent…
-
Auto Save / Invalid Operations Error.
Hi All, I have been searching community forum to this unsaved issue that I am having with my PMO but no luck so far and appreciate if someone could help me with this. According to what I have observed, the tasks sheet is not getting saved due to which some of the columns on Portfolio / Project Tracking Dashboard (Schedule…
-
Reverse the Ranking Order
I am working on ranking clients based on revenue with the highest revenue being number 1. In the end I want to build a top 25 list that could change on any given day based on new data. I used this formula to rank my items: =RANKEQ([Lost Client-SUM-BI Estimated Annual Revenue]@row, [Lost Client-SUM-BI Estimated Annual…
-
Incorrect Argument Set
It seems I have problems with the SUMIFS formula. Tried replicating one that works and that was a no go. =SUMIFS({031-Purchase Order - Completed}, "Completed", {031-Purchase Order - Amount}, {031-Purchase Order - Year}, 2025) I want to sum together completed invoices by year. Thank you in advance. Ali
-
SUMIF and NOT Functions
I am working with three formulas to collect data in the Summary. I want to add the NOT Function to these formulas to exclude the rows that are starred in the CCC column. =SUMIF({Region}, "Philadelphia", {Contracted}) =SUMIF({Region}, "Philadelphia", {07/09/25}) =SUMIF({Region}, "Philadelphia", {Difference}) Thank you