-
Formula syntax error
The current formula I have that works for calculating Labor hours is below =IF([Actual Duration in Hours]@row = 0, ([# of Staff Needed]@row * ([Baseline Duration in Hours]@row * 18)), ([# of Staff Needed]@row * [Actual Duration in Hours]@row)) The issue with this formula is the labor hours are always calculated even if the…
-
Is there a way to make a field required or highlighted based on a value from another column?
I would like to make our columns Risk/Issue and Mitigation either required or highlighted if our columns State or Dates Alert are in either Yellow or Red. Additionally, I would like to clear this field if both the State or Dates Alert are green if there were previously notes in those fields. Thank you!
-
VLOOKUP
Column1 Column2 Column3 1 1/1/20 Complete 3 1/1/20 Pending 2 1/1/20 Pending Column 4 Column5 Column6 3 1/1/20 Complete 2 1/1/20 Pending 1 1/1/20 Complete I need a formula that can identify when one of the cells in the first three columns is different from the cells in the last three columns. In this example, 3 should be…
-
Need to return a value with INDEX(COLLECT) but not if cell is BLANK
Hello, I am unsure if what I am doing is possible or not but I need to return a value with specific criteria. I need the latest "Revised Date" from the most recent amended version (Occurrence). However, it is possible the latest amended has no updated "Revised Date" field so it should keep the previous revised date.. In my…
-
Sum FTE Totals for all assigned projects
Hello, I am looking for some assistance with summing the total FTE hours per person assigned to a project. We use increments of .05 which is always rounded to 0 in the pivot app. I can't achieve this sum in reports, for some weird reason it won't allow me to group or summarize the Assigned Resource column. Is there a…
-
Sheet summary formulas automatically extending when new rows are added
Hi community, I have a lot of formulas in the sheet summary of my sheet. They all start like this "=COUNTIFS(Project1:Project149, NOT(@cell = "Epic Line"), [Row ID]1:[Row ID]149, ISNUMBER(@cell), ....." Now the sheet gets new rows added every day but my number 149 in the formula does not update automatically to capture the…
-
What is the maximum number of columns that can be displayed in a stacked chart widget ?
Hello, I need to compare data between 42 countries with a stacked column chart widget, but it seems we can only display 15 columns... ???
-
Indenting rows on a Mac
Hi, I'm trying to indent a lot of rows on a mac and can't figure out 1) how to select multiple rows at once and 2) why the indent option is greyed out if I manually select all the rows.
-
Summary Sheet calculate column totals
In the Sheet Summary section, I want to calculate three column totals. I have the below formula that is recognising the columns as 0, but if I add hours to any of the referenced columns, it does not add. =SUMIFS([Travel To Site]:[Travel To Site], [Travel Site To Site]:[Travel Site To Site], [Travel From Site]:[Travel From…
-
SUMIF matching rows and columns from another sheet?
I’m trying to create a resourcing table where for various projects, we complete how much time they will work on a project in the coming weeks. This is not a timeline or Gantt chart, so it doesn’t have dates, but it does have a list of all the projects and the hours are distributed over the weeks of the work. Instead it has…