-
Another if statement formula
I have what I thought would be a simple formula: =IF([Total credits per tuition year]@row > [Permitted credits per year]@row, "True") the formula is parse able; however, it's returning true whether the total credits per tuition year are greater than the permitted credits or not, except for the first row. The first row is…
-
I would like to search in a parant/child and get the result from another column
In the example you see BE and IT, with specific items. I'm looking for example for BE, item 4 and then want to see result mail 2, or IT, item 6 result mail 5. I tried index and match but I can't get it too work, does anybody have an idea how to solve this? Thx for your support Hilbert
-
Alert Someone Workflow
Does anyone have any idea as to why when a workflow is running for the 1st time on a row it's send the attachment out as it should but then if there's a change to the row and the workflow is triggered for a 2nd time it then does not include the attachment?
-
CountIF
Hi all this formual does not seem to work and cant figure out why? I am looking to find how many projects in the "Install progress" column and not complete and expected to completed before 01/01/2021. =COUNTIF([Install progress]:[Install progress], >"Complete": [Expected Comp Date]:[Expected Comp Date], < "01/01/2021")…
-
Formula in % Allocation Column?
I am certain this has been asked either currently or in the past, but is the capability to include a formula in the % Allocation column on the product roadmap? Right now, I have a column entitled "% Alloc Calc" next to the "% Allocation" column to calculate the % Allocation for my users. The users must ensure that both…
-
Convert text (19-NOV-2020 11:30:38 AM) into date
Hello, I am looking for a way to convert text in the following format: 19-NOV-2020 11:30:38 AM into a full date (with hour and minutes). Any suggestions? Thanks
-
reference another sheet - not from a cell, but pull from sheet summary formula
Hi, I need to pull a sheet summary formula into another sheet. I've tried right clicking in the desired cell, link to cell in another sheet, but can only link to actual cells in the other sheet. I can't navigate over to the formulas in the sheet summary section right hand side to pull that in. Another option I tried was…
-
Find Duplicates in Range Then Report Another Column
Dear Forum id like to Find Duplicates in Range Then Report Another Column. I have 1 column which lists drawing numbers and another with task IDs. id like a column that can look at this column and report a duplicate number, then report which Task ID Row it is in?
-
COUNTIFS
Not sure what I am doing wrong with what seems like a basic formula... I have a sheet which contains a list of projects - project owner, status etc. I am trying to create a separate summary sheet/table that consolidates the total number of projects for each PM, and subsequent columns the status of each project. I am using…
-
Gantt Chart Displays
Hello, Question regarding the display of section headings in Gantt charts: I would like for the section heading to only show the times when that section is active, rather than the whole window between the first day active and the last day active. An example- one of the Gantt section headings I am using is "Painting". Two…