 # Kam’s Profile

points
176 Happy Friday All:

I am trying to replace IF Formula with IFERROR so I do not receive #DIVIDE BY ZERRO Error. However, I receive Incorrect when I use the IFERROR. Can anyone help?

Existing Formula:

=IF(AND(TODAY() >= [Start Date (Planned)]18, TODAY() <= [Finish Date (Planned)]18), Good Day All:

I am trying to count the Children and grandchildren in my Status Column that meet a specific criteria. Currently its counting the parent and grandparent in that column Good Day All:

I am trying to add to my formula so that if the Due Date (Actual) is Blank/Empty, the RYG is Blank/Empty. My existing formula:

=IF([Due Date (Actual)]3 > [Due Date (Planned)]3, "Red", IF([Due Date (Actual)]3 < [Due Date (Planned)]3, "Green", IF([Due Date (Actual)]3 = [Due Date Good All:

I having a difficult time with my formula counting and meeting all criteria. I want the formula to count how many cells have "Not Started" and have the letter "D". Both have to be met in order to be counted. My current formula returns UPARSEABLE

Here is my formula below:

COUNTIFS({Epicor Hello,

I'm a bit stuck on how, if it is even possible, to create a burn down chart. I'm importing raw data from Jira (we don't have the plug-in... yet) and we want to show a burn down of our defects backlog, along with optimistic and pessimistic and forecast. I'm able to do it in Excel so I've Good evening:

I have broken down my Project Budget and spent a total of 13% of my Budget. I have used the formula to get the total sum (13%). However, I am challenged with adding to the  formula to get the remaining budget of 87%.

Sum Formula: =SUM(CHILDREN()) I have a project plan that I am now updating to establish dependencies. Everything was going fine until I updated one task's predecessors and a completely separate row's dates (and associated span in the gantt chart) started flashing. I'm guessing that there is some circular logic or something that Good Day All:

Is their a way to add a condition for summary task? For example, the condition would be to bold the Task Column if the Task is a Parent / Summary Task. Good Day All:

How do I take the following excel formula and use it smartsheet to get the same results

Excel formula =\$G\$30-2*SQRT(\$I\$30)

Results: 1.33

Smartsheet Formula =\$Expected\$26-2*SQRT(\$Variance\$26)

Results: UNPARSEABLE

I tried using ^2 for square root but still receive the same results. How do you structure your formula calculate negative if it is over 100%

For example, I am at 144% which is over budget

Current Formula =AC1 / [Project Budget]1

Results 144%, I would like it to calculate -44% once I am over budget.