-
Issues combining 2 formulas
I have the following columns: Expected Budget, Director Approval, VP Approval, Approved Projects. The conditions being, if Expected Budget is less than $10000, only director approval required, if more than $10000, both director and VP approval is required. On the Approved Projects, I would like to show if the project is…
-
Using JOIN-DISTINCT-COLLECT when values are not same data type
Hello, I am trying to create a string of values delimited with "+"s. It is part of a more complicated sheet, that matches Lot IDs to barcodes and other information from referencing another sheet. Essentially, I want the user to put in a lot ID (such as DXXXX) and the return to be a list of all the barcodes in the format:…
-
COUNTIFS criteria for "anything" in cross-sheet formula.
I've created a complicated cross-sheet formula that is supposed to the number of times the criteria "Mentioned" is found in Range 6 with an "any" criteria for Range 5 so that no matter what is in Range 5, if "Mentioned" is in Range 5, it will count it. This is what I tried: =COUNTIFS({Media Tracking Range 5}, {Media…
-
Calculating time between two timestamps in the same column
We were given some raw data from a virtual server and we need to calculate the session duration between 2 events in the same column and we cant figure it out the idea is to get the date from source table and on a formula sheet have the name of the agent, Date, Session Time start, Session Time End and Session duration Table…
-
Using TODAY function to calculate a half life
I am trying to use the TODAY function to continuously track half-lives of different radioactive material for inventory purposes. For example, if I order 50 mCi of lead 203 which has a half life of 51.8 hours, how can I make a formula to check how much has decayed in two days? Basically, is there a way to make the TODAY…
-
Drop down selection and cell updates
I have a column with drop down single select type name SLC Status. The entries in the drop down are "Requested", "In Review" , "Progress", "Testing", "Completed". There is a separate column for each entity ("Requested", "In Review" , "Progress", "Testing", "Completed"). My goal is- when Requested is selected from the drop…
-
How to get an approval after a decline in the automated approval request workflow?
Hi All, I have created an automated workflow based on a form submission that asks for the Approval of at least 3 individuals/roles. If an Approver declines, it will send and update request to the originator (Project Manager) and ask them to update information in the form. Once the Project Manager has updated the form, the…
-
How does COLLECT() with String Criterion Work?
I have a simple formula (I thought) that seems to broken. It seems to be centered around the existence of a String in the Criterion Parameter of COLLECT(). Formula: =IF(MIN(COLLECT(Date:Date, [Work Type]:[Work Type], "Mandatory"))=Date1, Hours1-6, Hours1) Result: #UNPARSEABLE Is it not possible to have a string Criterion…
-
AUTOMATICALLY MOVE A ROW WITHIN THE SHEET WHEN A CONDITION IS MET?
HI, I need to automatically move the rows that have reached a date within the same sheet into the next calendar year. When Agreements expire they have to be reviewed for the following year, I'd like to do this automatically. Is it possible to maintain the information within the same sheet? Thanks
-
Formula to change status based on current week/due date
Hello. I am attempting to have a status change to 'This Week' if a due date column falls within the current WORK WEEK. I am having a few challenges - 1) the formula is changing what is due 'this week' depending on the current date, NOT the standard Mon-Sun week, 2) I want anything with a blank 'Due' date column to default…
