Skip to main content
Answer

how to put 2 IIF statement together

  • February 10, 2025
  • 6 replies
  • 109 views
S
Freshman II
Forum|alt.badge.img
  • anytime i  join and validate this statement it good.
  • but when i save and try to people the sales order tab this show up
  • i am trying to put the statement on the statuse column to get different colors.
  • i need help?

Best answer by BenjaminCrisman

​@SandyA It worked for me but I had to replace each of the single quotes:

=IIF([SOLine.POCreate] = 'TRUE', 'orange60', IIF([SOLine.AMProdCreate]= 'TRUE', 'red60', 'default'), 'default')

 

    S

    6 replies

    BenjaminCrisman
    Acumatica Employee
    Forum|alt.badge.img+4
    • BenjaminCrisman
    • Acumatica Support Team
    • February 10, 2025

    ​@SandyA You could try something like =IIF([SOLine.POCreate] = ‘TRUE’, ‘orange60’, IIF([SOLine.AMProdCreate]= ‘TRUE’, ‘red60’, ‘default’), ‘default’)

     

    Have you already tried something like that?

    Chris Hackett
    S
    Freshman II
    Forum|alt.badge.img
    • SandyA
    • Author
    • Freshman II
    • February 10, 2025

    ​@BenjaminCrisman this is what showed up

    BenjaminCrisman
    Acumatica Employee
    Forum|alt.badge.img+4
    • BenjaminCrisman
    • Acumatica Support Team
    • February 10, 2025

    ​@SandyA Oh I think I had an extra comma before the last default, it should just be like ...’default’) ‘default’)

    S
    Freshman II
    Forum|alt.badge.img
    • SandyA
    • Author
    • Freshman II
    • February 10, 2025

    ​@BenjaminCrisman i took the comma away, and it still gave me this

    BenjaminCrisman
    Acumatica Employee
    Forum|alt.badge.img+4
    • BenjaminCrisman
    • Acumatica Support Team
    • Answer
    • February 10, 2025

    ​@SandyA It worked for me but I had to replace each of the single quotes:

    =IIF([SOLine.POCreate] = 'TRUE', 'orange60', IIF([SOLine.AMProdCreate]= 'TRUE', 'red60', 'default'), 'default')

     

    Chris Hackett
    S
    Freshman II
    Forum|alt.badge.img
    • SandyA
    • Author
    • Freshman II
    • February 10, 2025

    ​@BenjaminCrisman thanks, it worked

    BenjaminCrisman
    Chris Hackett
    S
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved