#DIVIDE BY ZERO Error Resolution Attempt
Good afternoon! I am trying to replace the #DIVIDE BY ZERO to ready "Update the tasks first!" so I thought =IFERROR(AVG(CHILDREN()) <> 0, 100/ AVG(CHILDREN()), "") would do it. What is the syntax for this please? Thank you!
Conditionnal auto numbering
Hi there, i'm looking the possibility to generate or not a number depending of the value on another column. For ex, column A : Yes/NO Colum B autonumbering If A = Yes, i will have a auto number, if no, the field stays blanck. Many thanks in advance !
Using Boolean Operators in Countif with Dates
Hello. I'm not sure why my formula isn't working. I'm guessing the issue is my syntax but I don't see where it is wrong, if that is the issue. I'm trying to get countif to count the number of rows with a date greater than 1/1/20. The formula does return a value but that value is 0. Here is the formula in case it's hard to…
Formula on Grand Parents row
Hi everyone, Please I do not know what I am doing wrong with my formula on % complete column, I have intention of calculating average on a grand parent 'the first row' which has other parents as indent. I used the formula =AVG(CHILDREN([Days to due Date]@row)) It is giving me above 1000%. please what do I do? Ps: I do not…
The ratio between child and parent
Hi, I would like your help. I want the parent to accept the values of the child,if all children have this value. For expample: If everyone has the value "All Homework is done" but not everyone has the value "Test Rehearsal is done " then only the value that appears in everyone will appear in the parent.
Calculating SLA based on time/hour formula
Hi @Paul Newcome I thought I would write a new thread and @ your name on this post. Hope thats ok. Taking this from Formulas for Calculating Time thread. --------------------------------------------------------------------------------------------------- @Paul Newcome What a thread! Came across this when I was looking for a…
Flag should turn red whenever over due day is over 30 days and status is not completed
Hi everyone, I have a 'risk' column with flag, it is supposed to turn red whenever status does not indicate 'completed' and 'due day' is already beyond 30days, except if the status was cancelled. I used the formula below but all the flags turned red automatically, I do not know what I am doing wrong, please help: What is…
Auto update % Complete while whenever status is updated
Hi Everyone, I have status column with drop down list of Not started, Cancelled, In progress and Completed. I would love the percentage complete column to auto populate anytime update is been made on status column. I would love to have Not started and Cancelled as 0%, In progress as 50%, Completed as 100%. Hope anyone…
Auto Numbering and Formula usage of Auto Numbering
I have 2 different scenarios and need some one to help, If I am using auto numbering tool for a particular column, the list will be in sequential order. Incase, I insert a row between the auto numbers, how it will respond ? Don't want the existing number to change. If I am using the formula to auto number based on some if…
Next Item Due
Hello, I would like to create a widget in a dashboard that shows the next task that is due in a list of upcoming tasks due. If I have a column that says the task with a corresponding due date column, how would I be able to display the nearest upcoming task due? Thanks.