Why isn't this formula working?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

If(

[Actual Finish]>Date(2015,3,27) and [PAYROLL EXCEPTION?]=false and

[All Tasks]="08.Finish" and

[Completed by:]="Alfaro, Noe",

[Board Count (To Pay)]*-0.5,

[Actual Finish]>Date(2015,3,27) and [PAYROLL EXCEPTION?]=false and

[All Tasks]="10.Sand" and

[Completed by:]="Alvarado, Miguel",

[Board Count (To Pay)]*0.15)

The bolded part works, but the second part of the formula does not get picked up.

Photo of Lynne8817

Lynne8817

  • 630 Points 500 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Rama

Rama

  • 0 Points
If(

[Actual Finish]>Date(2015,3,27) and [PAYROLL EXCEPTION?]=false and

[All Tasks]="08.Finish" and

[Completed by:]="Alfaro, Noe",

[Board Count (To Pay)]*-0.5,

If([Actual Finish]>Date(2015,3,27) and [PAYROLL EXCEPTION?]=false and

[All Tasks]="10.Sand" and

[Completed by:]="Alvarado, Miguel",



[Board Count (To Pay)]*0.15))

you needed to add "if" to the next condition
Photo of Lynne8817

Lynne8817

  • 630 Points 500 badge 2x thumb
I'm sorry, but this didn't work either.  I copied and pasted the formula above.  Thank you
Photo of Rama

Rama

  • 0 Points
just check the parenthesis and make sure the commas are in the correct place
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 4,526 Points 4k badge 2x thumb
TRY THIS:

If(

[Actual Finish]>ToDate("03-27-2015") and [PAYROLL EXCEPTION?]=false and

[All Tasks]="08.Finish" and

[Completed by:]=ToUser("joelafaro@xxx.com"),     /// IF the Completed By is a User field

[Board Count (To Pay)]*-0.5,

If([Actual Finish]>ToDate("03-27-2015") and [PAYROLL EXCEPTION?]=false and

[All Tasks]="10.Sand" and

[Completed by:]=ToUser("miguelalvarado@xxx.com"),  /// IF the Completed By is a User field



[Board Count (To Pay)]*0.15))



What error message does your formula give you - that will help.  Your "date" format system works (although that's not one I've ever used before) - but I think the error is with your [Completed By:] which appears to be a User field type; rather than a text field.
Photo of Lynne8817

Lynne8817

  • 630 Points 500 badge 2x thumb
I don't believe the problem is with the date field because the first part works fine.  It's the 2nd "IF" scenario that doesn't pull-in...
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 4,526 Points 4k badge 2x thumb
Does your formula work with only 1 IF?  Does the formula have any errors when you save it; or the formula just isn't calculating anything?
Photo of Lynne8817

Lynne8817

  • 630 Points 500 badge 2x thumb
Only the 1st part works with 1 IF.  No, formula does not have errors...just doesn't calculate.  Thx
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 4,526 Points 4k badge 2x thumb
If a formula isn't calculating, then you need to make sure that each component of the second IF is filled in the way the formula expects it to be:

[Actual Finish]>Date(2015,3,27) and
[PAYROLL EXCEPTION?]=false and
[All Tasks]="10.Sand" and
[Completed by:]="Alvarado, Miguel"

If it still isn't working, please contact me offline - it will likely need a screenshare to review/fix.
Photo of Lynne8817

Lynne8817

  • 630 Points 500 badge 2x thumb
It's working now.  I had to go back to the completed by list and re-enter the name after I had put the formula in.  Entered it the same exact way it was entered previously...odd.  Thank you to all.