-
MAX and COLLECT
A different phrasing of my earlier question with a better "picture" to explain what I need. I need to look up the MAX date for a task # on a sheet which houses all of the historical data for the completion of various tasks. So, Two sheets. One Sheet is a "Master Task Sheet" with each task only appearing once. I need to add…
-
Change Metric Widget references based on Checkbox
Hello, I have a question regarding Metric Widget's that would appear on a Dashboard. I do not think this is possible, but I'm asking regardless. I have a single cell selected that contains a simple sentence. Is it possible for the Metric Widget to update itself to another cell based on the clicking of a checkbox? So, in…
-
RE: IF function - Is it possible to return current cell value when using IF function
Simple example: cell value could be equal any number between 0-10 If(cell value@row = 15, 25, [current cell value])
-
Find largest date for a given task from a list of multiple tasks
I have a need to lookup the most recent date upon which a task was completed. Each task has it's own unique number and upon completion an entry is made into an "archive sheet" of tasks completed in the past. So, a very simplified example is that I am looking to utilize a formula to find the largest (i.e. most recent…
-
Unflag after marked completed
Hi, I am new to formulas. What can I use for the following: I currently have this formula to flag an over due task: =IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1) The formula on top works fine, but when the user clicks on the completed checkbox the red flag still appears. I want the red flag to disappear when…
-
COUNTIF with keywords
Hello, I am trying to set up a formula to count a cell if it contains a certain keyword (e.g. "communication"). The cell itself won't be only composed of that word, but will just contain it. My formula so far is =COUNTIF([Job Classification]:[Job Classification], CONTAINS("communication", [Job Classification]:[Job…
-
Sumifs 2 columns
Hi, I need to add a column to my sumifs formula. I need to check if there is a payment in a new columns This is my current formula. =SUMIFS({payment Log Ret Dep}, {Pay Log RETAIN}, AND(IFERROR(WEEKNUMBER(DATEONLY(@cell)), 0) = Week@row, IFERROR(YEAR(DATEONLY(@cell)), 0) = 2022), {Payment Log PM2}, "Dean Hammel")
-
TODAY() Seems to cause #BLOCKED message
I have researched this issue and I have tried several solutions. I have set automation to insert the current date into my project schedule sheet, then automation to lock rows and then automation to unlock rows. This did not clear the issue. I have created a separate sheet with automation to insert the current date into the…
-
Combine two sheets to one report
Hi Team I am trying to combine two sheets into one report. Have added the two sheets. But wondering if it is feasible to combine the two sheet columns and data into one where the data can sit against the common Project name vs below. The Project nomenclature is the same on both sheets. Trying to see if we can have the…
-
All Dates populate based off one date
Hello, I am trying to create a sheet where I can put in one date in the Target Start Date column then all other dates populate from that date based off the duration it takes to do all the task. Is this possible?
