-
Using multiple Star symbols based on age of request
Howdy, I manage an intake process where my colleages fill out a form to request a specific service. In my project dashboard, I want to have symbols to indicate the age of the request. So, 1 star would be equal to a request 1 month of less; 2 stars = request 1-2 months etc. I can't seem to get any formula to work, any…
-
Assigning One Person to Another Person
I have AR Specialists that are assigned to Property Managers. Each time I enter a new property and select the Property Manager from the drop down list, I want the AR Specialist column to automatically populate. If the Property Manager in column 1/row 1 = XX or XX or XX, then the AR Specialist = XX If the Property Manager…
-
Date Column to Autopopulate Fiscal Year Column
Hello, I have 2 columns that have a start date and end date. Once both of these dates are entered, is it possible to automatically populate the associated fiscal year(s) within the FY column? Thank you in advance!
-
Send as attachment to "current user"
HI, I've created a report and have the filter to "current user" only so only the current user can view their job order. So my question is if I set up a recurrent "send as attachment" email for the team individual, will it only show their job order or will it show mine since I'm the one who is setting up the reoccurring…
-
IF AND with Less and greater than is not working
I am trying to use this formula. IF(AND([Time Remaining]@row = "Closed", [Closed Date ageing]@row >= 90,[Closed Date ageing]@row <= 180), "90-180 Days", "More") where [Closed Date ageing]=203 but still it is giving output "More" Can you please tell me where I'm making mistakes? Thank You Suman
-
IF Function and Cells without Data
I am trying to set up an IF function to automatically set a status using the RYGB symbols and how far away the target completion date is. I have had some success with the following =IF([Target Completion Date]1 <= TODAY(-1), "Red", IF([Target Completion Date]1 <= TODAY(5), "Yellow", IF([Target Completion Date]1 >=…
-
Summary Report pulling tasks count based on items checked
I need a count formula or any formula that counts the number of late, not started, complete and in progress tasks that has milestone or key activity checked. The purpose is to create a semi-circle chart (sample chart below is the count that will pull into a summary report) on a dashboard to show the different counts.…
-
Cross Sheet SUMIFS #unparseable
Hello Community, I am trying to get a cross sheet SUMIFS working and I am stuck on something in the syntax. I can get the exact SUMIFS to work within a sheet but when I try to create the SUMIFS on a summary sheet I get #unparseable. I am sure it is right in front of my face but I can't seem to fix it and I haven't found…
-
How to remove conditional formatting from Control Center Template - Visual Symbol change
So we were using the 3 visual symbols R/Y/G for Health but have added Blue now to that formula. I need to update all the plans globally to now have the R/Y/G/B symbols. I am getting an error that conditional formatting is preventing the update. When I delete the conditional format rules from the template file it is still…
-
How to combine multiple data entries (rows) to a single row with additional collumns?
Hello, I am working towards combining data from multiple entries into a single row. An example of what I have is in the first Photo and what I need is in the second photo. So far, I have been able to make a sheet that identifies the list of unique row names (i.e. "1" and "2" ) I am having trouble now pulling the data…
