Forum Discussion

RonaldvdH's avatar
RonaldvdH
Icon for Post Patron rankPost Patron
7 years ago

Adjusting my formula

Ive got a calculated column based on multiple variables   Test = IF(Adressen[Status Site-Survey]<>"";( IF(Adressen[Status Site-Survey]<>"null";( IF(AND(Adressen[site-survey gesloten]=BLANK();Adr...
Need Help
RonaldvdH's avatar
RonaldvdH
Icon for Post Patron rankPost Patron
6 years ago

jdbuchanan71 this formula is getting close except there is no formula if the result is bigger then today ()+5

Besides ive made a fault in my reasoning because the formula shouldn't be Today () - 5 but Today () + 5

 

For example if i need tot turn in my report on november 5th that means the formula should read 'Sisu inleveren binnen 5 dag(en)' given it's november 1st.

 

Basically that means i have 5 days to turn in my report but if i have more then 5 days left it should read that i have more then 5 days left so the formula should state that IF the result is bigger then Today () + 5 then it should read 'Sisu inleveren > 5 dag(en)

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
6 years ago

RonaldvdH 

That would be this then.

Test2 = 
IF (
    Adressen[Status Site-Survey] <> ""
        && Adressen[Status Site-Survey] <> "null"
        && Adressen[site-survey gesloten] = BLANK (),
    SWITCH (
        TRUE (),
        Adressen[Sisu gepland] = BLANK (), "Sisu nog niet gepland",
        Adressen[Sisu gepland] < TODAY (), "Sisu te laat",
        Adressen[Sisu gepland] > TODAY () + 5, "Sisu inleveren > 5 dag(en)",
        Adressen[Sisu gepland] > TODAY () + 4, "Sisu inleveren binnen 5 dag(en)",
        Adressen[Sisu gepland] > TODAY () + 3, "Sisu inleveren binnen 4 dag(en)",
        Adressen[Sisu gepland] > TODAY () + 2, "Sisu inleveren binnen 3 dag(en)",
        Adressen[Sisu gepland] > TODAY () + 1, "Sisu inleveren binnen 2 dag(en)",
        Adressen[Sisu gepland] > TODAY () , "Sisu inleveren binnen 1 dag(en)",
        Adressen[Sisu gepland] = TODAY () , "Sisu heute"
    )
)