-
What am I doing wrong? Trying to count how many say not started in the month of dec 2020.
COUNTIFS({Request Tracker Range 2 - Status}, CONTAINS("Not Started") >= DATE(2020, 12, 1), {Report Request (Test Version) Range 3}, <=DATE(2020, 12, 31))
-
Parent/Children Flag Formula
Hi all, I'm trying to create a formula that will flag a child row if a certain date is within a # of number of days, but I'd also like it to flag the parent row if any of the children row are flagged. I am currently using these two formulas: for the parent row - =IF(COUNTIF(CHILDREN(), =1) > 0, 1, 0) . . . and for the…
-
Can I suspend an automated workflow from working under a specific condition?
I have an automated workflow for our installations on-boarding process which contains multiple approval points, however if the installation is suspended is there any way I can add a condition to the workflow which recognises this and prevents the approvals until it is unsuspended again?
-
Clearing the Risk Flag
Hi there, I am trying to figure out a way to write a formula which will do a couple of things. If the % Complete is less than 75% 30 days from end date = At Risk flag; If the % Complete is 100% 30 days from End Date = Clear Flag If If Status "On Hold" is selected (regardless of the % Complete") = At Risk flag; If the…
-
Pulling multiple rows of data in column from source sheet to a target sheet
I would like to pull multiple rows of data from a single column and populate it in a column in a target sheet while filtering. For example I have an auto updating sheet fed by API that auto-deletes and refreshes every 15 mins (No helper columns allowed). I'm wondering if it is possible to pull Trailer number by load…
-
I am struggling, quite a simple one
I have a column based on form submission, asking the question with answers yes and no as selections, I thien want to create a score in the next column based on Yes = 2 and No = 1, I cant get the function to work, so far I have created =IF([Reported MSK ill health - 6 months]@row = "Yes", "2") which picks up the Yes's but…
-
Copy and paste link to another sheet?
I use linked reporting extensively so that I don't have to repeat data capture. I often need to copy and paste the same link down a column in a sheet. However, when I copy and paste only the value transfers, not the link out to the data in the external sheet. Is there a way to do this?
-
Count with criterion.criteria within multi-select cell
I have multi-select cells in a sheet. I can use countm to count all selected items in a specific cell. However I need to count specific selections based on criteria. For example: A dropdown contains: L1-ABC, L1-LMN, L1-XYZ,L2-ABC,L2-LMN,L2-XYZ, L3-ABC,L3-LMN,L3-XYZ One cell has: L1-ABC,L2-XYZ,L2-ABC,L3-XYZ I want to search…
-
formula for calculating between dates
Hi, I am looking for a simple formula to count the difference between 2 dates in number of days. Where 'Finish' is the completion date of project, and 'TODAY' is today's date, and the formula needs to calculate the difference between the two. I have tired to use the following formula but it just returns #DATE EXPECTED:…
-
If checked subtract using a date, if unchecked subtract using another date
Good afternoon, I am trying to create a day counter that will be counting until another date is filled. I thought nesting if formula's would work, but so far I am not successfully creating the correct formula. A screenshot below will hopefully help and here is the formula I wrote that is giving me the "Incorrect Argument…
