-
Data Shuttle Expression Not Working
Hello, I'm trying to create a Unique ID using an expression in Data Shuttle that looks at three columns. First, if there is a value in column A, then use that, if not use column B to create the first value (Value 1). Then I'm checking in column C to see this there's a value (Value 2). Then, I create the Unique ID, by…
-
Record a Date automation not running
I have a summary sheet that has a date (column type is set to date). I have an automation which should run every night at 9:00 p.m. to update the date to the current date (so the sheet will update automatically). However, the automation never runs. Any ideas?
-
IF/AND Formula help please
Hi all, Looking for some help with the following IF/AND Formula please which could result in the following answers: If Task Status not equal to "Completed" then return "Currently Incomplete" If Task Status not equal to "Completed" & the task is late( End date(actual)+Time Due(Actual) are greater than their targets, return…
-
Red Flag Trigger based on multiple conditions
Hello! I am attempting to adjust the red flag trigger in a RAID log so that it only displays if the due date is in the past and the status is "In Progress" or "Not Started." The other option would be if the due date is in the past or the status is not "Complete. My equation attempts continue to return as unparseable. All…
-
Formula that counts the total of red dot symbols in my status column
Hi everyone, I have a project plan with several rows. There's a STATUS column in which traffic lights colours (gray, green, yellow and red) appear depending on the closeness of the task to its deadline. In another sheet, I'd like to link a cell to the STATUS column and use a formula that counts how many red dots there are…
-
Is it possible to reference another sheet's dropdown list in a formula?
I'm working on a formula to reference another sheet, where the other sheet includes various dropdown menu columns. I want the formula to include an IF statement where, when a cell is selected in the sheet, it populates a corresponding dropdown menu from another sheet. I completed the formula, but the dropdown menu does not…
-
Problem w/Index - Match formula
I using the following formula, =INDEX({Contract Focal Point}, MATCH([Contract No.]@row, {Contract No.}), 0) And it works for the first row when i input in the contract number into the column. On subsequent rows when i input the contract number it pulls back incorrect information and if I put in a fictious number it pulls…
-
Count Down Formula
Hi All, Does anyone have a formula that will count down to a specific date? Thank you.
-
Invalid Operation
Good morning, I am trying to sum the entries that are greater than 30 but less than 60 days old. =SUMIFS({011-AP Archive -# of Days to Complete}, >30, {011-AP Archive -# of Days to Complete}, <60) I was able to do this same formula with a COUNTIFS but its' not working the same, what am I missing.
-
Trying to create COUNTIFS formula
Hello. I am trying to create a formula that will count occurrences of multiple things happening. Anytime a certain person (Name column) is found and anytime a date qualification (Date Qualification Completed column) was completed withing the last 90 days. I am using a data sheet as I want to use this output for a…