-
Slow sheets corrupting data in Pivot, summary sheets, etc.
We have some big sheets with a lot of complicated cross-sheet formulas and cell links. We use reports, pivots, and dashboards to collate and summarize data. Recently, we've had a few incidents where a sheet loading slowly (apparently) causes things to malfunction. A dashboard metric will appear as "#CIRCULAR REFERENCE", or…
-
Sumifs formula with a date
I'm trying to calculate a total value if two criteria are met using the sumifs formula but I keep getting a 0 result. I think the problem has to do with the format of the date field. The formula is =SUMIFS({Cost Tracker Testv1.2 Range 5}, {Cost Tracker Testv1.2 Range 4}, "Actual", {Cost Tracker Testv1.2 Range 7},…
-
How to calculate number of months between 2 dates
Hi, I want to calculate number of months or years between two dates. How to use the below formula which we can use in Excel to calculate that: =DATEDIF(Date column,TODAY(),"M")/12 If the date is 4th Jul 22 then the number of months from today should come to 0.3 and if date is 21 May 2021 then the number of months from…
-
Help! trying to figure out a formula for dates!
Hi! I am trying to create a formula for dates. I have start date and end date which are 70 days apart & i need to have a formula that calculates the % complete, based on the start date and current date.... I have tried and tried to figure this out but i am stuck! Thank you!!!
-
COUNTIFS Formula keeps returning 0 can someone explain to me why?
I Need Help this formula keeps returning 0 but there are fields that match this criteria and I cannot figure out what the problem is I am referencing the sheet below in my formula =COUNTIFS({Hires Listing_Report (3) YTD 10/7 Range 2}, "Ramiya Iyer", {Hires Listing_Report (3) YTD 10/7 Range 1}, >=DATE(2022, 9, 11), {Hires…
-
IF/AND/ISDATE COMBINATION
Hello all, I am trying to say If GPD Release Date UK has a date equal or less than GDP 15 Day Target Date-UK and HA Approval UK has a date, then the result should be "On-Time", if not then "Late". But i keep getting #INCORRECT ARGUMENT SET . What am i doing wrong here? =IF(AND([GPD Release Date-UK]@row = <[GDP 15 Day…
-
Unable to use =(PARENT()) with a Date column?
I can't seem to get =(PARENT()) to work with a date column. Is that not possible? Thanks! Ann
-
Alert workflow when item is in a given status for 10 days
Hi there -- I have a use case where I need to send a specific person an alert if a row's Status column has remained in the "Upcoming project" status for 10 days. Likewise, I need to send this same person an alert when a row's Status column has remained in the "v1 to ESG analyst" status for 10 days. I think I need to use a…
-
% Complete showing effort is late when it is on schedule
I have a set of tasks that are currently on-track, but the % Complete is calculating only at 9%. When I do a manual check I find that I am 30% into the effort and 26.25 complete. Why is the % Complete showing only 9%?
-
Help turning tasks yellow less than 30 days till finish
I have the R/G ok, blue for complete, but I cant seem to get it yellow if the finish date is less than 30 days away: =IF(Status@row = "complete", "Blue", IF(Finish@row < TODAY(), "Red", IF(Status@row = "In Progress", "Green")))