-
Requests Per Month
I am trying to figure out a formula that will allow me to keep track of number of requests per month. I have tried countif, countifs etc., without much luck.
-
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!
-
Formula with multiple answers
Hello, Is there a formula for a row that can have multiple answers? I have one column A with names, and depending on that name in column A, I want a different number to appear in column B For example If column A=Mary, return 245 or column A=James, return 548…..etc. I have 5 names with 5 different values associated with…
-
STATUS UPDATE - Based on Date
Hello, I want the process wherein once we click on the task status for example: In Progress then start and end date are added, time time line status will read it immediately if it is "ON TIME" or "DELAYED" based on the end date. If we click on the completed - and the end date is not yet on the past, then it will ON TIME -…
-
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…