-
Row report to show data from 2 sheets if column data matches both
I have 2 sheets with very similar, if not identical, data except each sheet is for a different year. I am looking to create a row report to show only the data if the category column matches on both sheets to compare the differences from this year to last. I already have a formula to remove the parent row from the report. I…
-
Alerts on duplicate values
We are assigning a unique identifier across 3 separate sheets. The unique identifier creation is a manual process at this stage as this is a short term problem we are solving for. Is there an automation that we can use to notify if there are two of the same values for different lines? We have a report pulling in the data…
-
Blank Value for Schedule Health
Hello, working with the formula below for schedule health: =IF([% Complete]@row = 1, "Blue", IF(Status@row = "Cancelled", "Blue", IF(Status@row = "On Hold", "Yellow", IF(TODAY() > [End Date]@row, "Red", IF(AND(TODAY(10) >= [End Date]@row, [% Complete]@row < 0.5), "Yellow", "Green"))))) Would like to add: If [End Date]@row…
-
Card view not displaying due dates
Hi folks. I have a sheet that has multiple dates columns on it (screen shot below). I want to display ONLY the due dates. However, the dates that are displayed are my "Week of" and "Check-In" dates. I'm wondering why I'm unable to change it and if there is a way to do so. Thanks!
-
IF formula for date and text in the same cell.
Hi, I currently have this formula for a cell: =IF(AND([Quote Validity]62 < TODAY(), ISDATE([Quote Validity]62)), "EXPIRED") However, if I need to put anything other than a date for Quote Validity cell. It returns an "#INVALID OPERATION" What needs to be added to that formula so when a text, besides a date is inputted, it…
-
notification on row deletions
I have a workflow setup to notify me when a row is deleted. All this does is send me an email that Username has deleted a row. How can I have this notification tell me what was deleted. I tried to define the following email text but all variables in the email are blank. How can we make the row deletion notifications…
-
Control Center - Project data Update
Hi, I am really new to control center. As suggested I followed the training . I have added all the new values in intake sheet .Using SCC blueprint i have created the new project. Templates , Reports , Project dashboards & portfolie dashboards working perfectly. About my problem , i would like to change project manager for…
-
Using join/collect to return task description when task is complete
Hi, I am trying to create a formula that returns a collection of tasks descriptions when the task is marked as 100% complete. The overall goal is to show, per project phase, what tasks have been completed to date. Here's what I have currently: =JOIN(COLLECT({Project Plan - EOL Asset Enterprise Range 1}, {Project Plan - EOL…
-
Single Row of Data on Summary Report
Hello, I am setting up a Summary Report based on a few different sheets that all have Summary fields. I want to then have this information display in a single row on a Dashboard but I cannot figure out how to get all the information to appear on a single row. My primary column lists the Sheet Names which I'm confident is…
-
Folder ownership within a workspace
we have multiple workspaces set up for each customer to prevent accidental cross sharing. when our PM's create a new project folder within the customer workspace the ownership of the folders and sub files is all assigned to the workspace owner. Can Folder ownership be individual within the workspace if not, an workspace…
