Forum Discussion

havish_madhvapaty's avatar
havish_madhvapaty
Copper Contributor
Dec 29, 2021

Increase size of Evaluate Formula Dialog Box

The Dialog box should be resizeable - it a must for long formulas.    
Formulas and Functions
mathetes's avatar
mathetes
Gold Contributor
Sep 12, 2022

abdullahabid 

 

It still looks to me as if you're working with a single formula; maybe a single formula with intermediate steps (nesting)...my suggestion was that you break it apart into separate formulas.

 

Is it possible for you to post the entire formula, not just what you're seeing in the "Evaluate Formula" dialog  box?

abdullahabid's avatar
abdullahabid
Copper Contributor
Sep 12, 2022

mathetes 

FG_Availibility Formula is defined as follows and it further calls the multiple helper and intermediate functions:

=IFNA( IFS( CC_IsPast,"--", AND(NOT(CC_HaveTasks),CC_IsToday),"Target Achieved", AND(FI_MaxSlotsToday>=7,OR(CC_IsFuture,CC_IsToday)), "Available", AND(AND(FI_MaxSlotsToday>=5, FI_MaxSlotsToday<=6),OR(CC_IsToday,CC_IsFuture)), "Partially Available", AND(AND(FI_MaxSlotsToday>=2,FI_MaxSlotsToday<=4),OR(CC_IsToday,CC_IsFuture)), "Difficult", AND(FI_MaxSlotsToday=1,OR(CC_IsFuture,CC_IsToday)), "Very Difficult", AND(FI_MaxSlotsToday=0,OR(CC_IsFuture,CC_IsToday)), "NOT Available", AND(FI_MaxSlotsToday<1,OR(CC_IsToday,CC_IsFuture)), "Invalid Targets" ),"Add new Week in summary")

 

  • mathetes's avatar
    mathetes
    Gold Contributor
    Sep 13, 2022

    abdullahabid 

    I just realized you never actually say you're looking for help with this formula. The whole point up till now has been that "the dialog box for evaluating formulas needs to be larger."

     

    So are you asking for help with the formula as well? 

     

    I find it easier to analyze, though still not easy for a formula this long, to display it thus:

    =IFNA(

    IFS(
    CC_IsPast,"--",
    AND(NOT(CC_HaveTasks),CC_IsToday),"Target Achieved",
    AND(FI_MaxSlotsToday>=7,OR(CC_IsFuture,CC_IsToday)), "Available",
    AND(AND(FI_MaxSlotsToday>=5, FI_MaxSlotsToday<=6),OR(CC_IsToday,CC_IsFuture)), "Partially Available",
    AND(AND(FI_MaxSlotsToday>=2,FI_MaxSlotsToday<=4),OR(CC_IsToday,CC_IsFuture)), "Difficult",
    AND(FI_MaxSlotsToday=1,OR(CC_IsFuture,CC_IsToday)), "Very Difficult",
    AND(FI_MaxSlotsToday=0,OR(CC_IsFuture,CC_IsToday)), "NOT Available",
    AND(FI_MaxSlotsToday<1,OR(CC_IsToday,CC_IsFuture)), "Invalid Targets" ),
    "Add new Week in summary")

     

    And quickly scanning that I don't see any syntax errors.....so what (if you are seeking help with the formula per se) happens when it's in context?

Resources