-
Help with Auto-populating dates
Hi All, I have been trying to figure out how to auto-populate dates. I've figured out that if I enter a date, type in the desired duration of when I'd like the task due, it populates the due date for me. All of that seems like it's project in the future and I'm running into this particular problem. Let's say I need to…
-
Calculating a column based on date
I'm trying to total up the job value column based on weekly totals. Can I have the formula calculate the weeknumber or do I have to create a helper column?
-
Change Status to "Submitted for Approval" or ""Returned to Action Party"
1. I have Action Items that can be reviewed by up to 3 Reviewers (Reviewer 1, Reviewer 2, Reviewer 3) before being Submitted for Approval. Reviewers are identified by Name. Reviews are done in parallel. 2. Some Action Items are reviewed by all 3 Reviewers, others by just 1 or 2 Reviewers. 3. After review the Reviewer uses…
-
SUMIF on Cross Sheets
Hello, I've been trying to create a roll-up based on "Region" from another sheet and I either get "0" or invalid argument. On inventory sheet I have multiple columns with Budget, Actuals, ect and would like to sumif based on Region. The formula below returns "0" =SUMIF({Inventory Range 1}, {Inventory Range 2} = "ProServ…
-
Automatic RollUp of data from multiple projects
Hello everyone ! I could use some help with some dashboard 101. I've been trying to find a way to roll up data for a while without success. Let me explain the situation: I've created a "project folder template" (including sheets, report and a dashboard) that I can easily copy for every new project I'm creating (please…
-
Formula Help!!!!! PLEASE
I have a data set with a bunch of dates 09/03/19 09/04/19 08/19/19 07/01/19 You get the idea.... Im trying to get a count of "incidents" by month... but I cant get the formula to work!!! July = 10 Ive tried... (below) and many others... =COUNTIF({(NEW) Support Request (USER) Range 10}, MONTH({(NEW) Support Request (USER)…
-
Reporting progress between date ranges
Dear Community, I have searched the community for some solutions for what I am trying to achieve…but can’t quite get there. I am working on some metrics around planned vs actual progress that I will plot on a chart. I have created a ‘metrics’ sheet to count the tasks planned to be complete at the lowest outline level from…
-
Server/Local sheets get out of sync, some permanently
Hi all, I am working with SS support but I thought I would reach out here as well According to T2 support ...If our server has not processed all data/ formulas before a save is made the sheet may show a different version than our server shows. In most cases the dirty save only lasts for the first 2 rounds of saves.... This…
-
Calculate RAG Overall Project Status
I have projects that are recording Red, Yellow, Green for multiple categories (Budget, Scope, Schedule, Resources), and I would like to be able to calculate the Overall Health by evaluating each of these individual status' and pulling the lowest color as the overall status. What I need to be able to do is calculate the…
-
If Current Month
Hi I'm trying to write a formula that will show me a column for the current Month Currently formula =If(Month(date column)= 9, [Project]1)- This works and displays the correct cell, however I want the column to change with the month so I tried= IF(Month(date column)=Month(Today()), [Project]1), I get an error Any…