-
How to make Networkdays formula display less than 0 values
Hello, I am having multiple issues with my calculations using MAX and NETWORKDAYS. In the “Invoice Variance” field my numbers are displaying as negative numbers using the following formula =MAX(NETWORKDAYS([Invoice Submission Due Date]@row, [Original Invoice Receipt Date]@row, [Resubmitted Invoice Receipt Date]1:[2nd…
-
Clear check-box, without clearing associated Due Date columns
Hi I'm setting up a sheet for reoccurring tasks that have different intervals. I have a task column, interval column, last check, next check and a check- box. When the checkbox is ticked the Last check updates to todays date and this updates the Next check date, calculated from the number of days in the interval column. Is…
-
Automatic RYGB Lights
Hi All, Currently I'm trying to make my RYGB column give the right color light when it meets certain criteria. This must be based on a Start Date column, End Date column and a status column, but I can't seem to figure out a formula that works. So the way it should work is like below: Is there anyone who might know a…
-
IF Formula questions
Apologies in advance, this is a real newbie questions. I am trying to create an IF formula which checks if the value of column Chargeable is TRUE it should then divide the value in Quantity cell by 7 and store in the formula cell. If Chargeable != true then set the value in the formula cell to zero. Following is what I…
-
How can I find a position of a character in a string?
Hi all - I'm trying to find a position of a character within a string, which in theory seems simple - just use the FIND() function. What I'm struggling with is when there are multiple instances of the value, and I want to start at the 4th instance (for an example) of it. Here's an example of the String I'm trying to parse:…
-
Can you help me simply this formula. I think I can use "And" and "Or', I just dont know how.
=IF(sum( COUNTIFS({ML student status}, "No",{ML status}, "Qualified occupied"), COUNTIFS({ML student status}, "No",{ML status}, "UU Pre-Approved by Compliance"), COUNTIFS({ML student status}, "No",{ML status}, "QV Pre-Approved by Compliance"), COUNTIFS({ML student status}, "No",{ML status}, "Unit is in Rehab"),…
-
Formula Issue
I have a form where I am collecting data on a metric sheet to translate to a dashboard for a group. I have two questions: I am using =COUNTIFS to collect the answer that is considered a violation + the date of the line, and am separating it out by months. When all the answers that are violations are "No", my formula works…
-
Update TODAY() function automatically improvements
Hello SS Community, I have been using the required automation to update my sheets automatically since I am using the TODAY() function on my rows. The current setup I have is to check an unchecked box and vice versa. Other solutions found here:…
-
Formula to count two different values in the same column
I'm trying to create a summary field formula to count two different values in the same column. The formula seems to work, but it returns a value of "0" which I know is not correct. =COUNTIFS(PMActivity:PMActivity, "303", PMActivity:PMActivity, "307") Hoping someone can point out where I've gone wrong on this one. Thank you…
-
How to use COUNTIFS + CONTAINS in one formula?
Hello everyone, Already grateful for your assistance in advance. I'm having some trouble coming up with a formula that can determine how often a multiple-choice topic appears in a column. I've used the COUNTIFS function and it worked well on the column with single-choice topics. But when I use the formula CONTAINS, it…
