-
Extract text string into separate cells
I have predecessors which I converted to text in a separate cell. Below is what it looks like… If I wanted to extract "181," "182," and "184SF - 20w" into separate cells (three cells in total) how would I do that? Thank you!
-
Same Formula Giving Error in Different Cells
Hello, I have a formula that should be the same for all three calculations I am trying to do but two are giving an error when I think everything about them is the same. Here are the two formulas I am using: The Insp Date produces a number/no error and the Weld Date produces #INVALID DATA TYPE. The are in the same column on…
-
Will IF(MAX(Collect work?
Hello community, I am using a MAX(Collect( formula to pull in a number from another sheet where I calculate the number of days we have to lock a project's files after completion - this is pulling into our project tracker. The origin sheet is calculating the countdown number based on one particular type of work request and…
-
Formula for child row seq#
What formula needs to be in column Step# rows 3-7 to automatically keep the Step# in sequence when a child row moves up/down?
-
Health Formula
In my task sheet health column I am trying to write a formula that I desperately need help with. I have a column labeled status. It is a drop down column where I can select "Not Started", "In Progress", or "Complete". I would like my health column to reflect a color based on the input in the status column. Green if it is…
-
Change dot color based on date field
I am trying to come up with a formula that will change a RYG symbol to green if the date in another column is within the first 14 days of a month. The symbol column is already set up with the right column type. Thank you for the help!
-
Change a checkbox state in one sheet based on the symbol in another sheet.
I want to check a box in my metadata sheet (restricted to checkbox column) if the overall health of my project is red. The referenced cell/column is restricted to symbols, green, yellow, and red circles. The formula I came up with is returning #INVALID REF. This will all end up in a report and will be an automated process…
-
Comparing Columns on Two Different Sheets
I have two sheets that I need to compare data and highlight any matching data. If Sheet "A" query column matches any of the data in Sheet "B" query column, then the matching data in Sheet "B" query column needs to highlight. I've not had any luck finding a formula that works. Any thoughts?
-
Index Match function with specific criteria
Hello, I have successfully put together a formula to pull an Investigation tracking number to a cell when the product name on the new sheet matches the product name on the Investigation Tracker sheet. =IFERROR(INDEX({Investigation Tracker Range 1}, MATCH([PO Item Description]@row, {Investigation Tracker Range 3}, 0)), "")…
-
Combining the WEEKNUMBER and YEAR formulas
Hi, We have many live projects at any one time which all share cross functional resources. I want to create a report which shows all tasks, per week, on all projects. To do this I have added a column showing the Year Week using the formula WEEKNUMBER. However our projects are long, 2+years in some instances. So if I were…