Forum Discussion

VW's avatar
VW
Qrew Trainee
3 years ago

Formulas - IS Not Null & If Then

  Hello! I have the following fields in my report: "Date Manager Entered" "Last Day" I'd like to create a formula that does the following: 1. See if there is a date entered in "Date Ma...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
try this as a formula text field

IF(
IsNull([Date Manager Entered]),"", //  if empty, then result is empty quotes. 
// else we know there us a date
ToDays([Date Manager Entered]-[Last Day]) < 5, "No", "Yes")

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
VW's avatar
VW
Qrew Trainee
3 years ago

Sorry, if possible, I'd also like to update the formula to calculate the number of weekdays between the two dates.

 

I tried:

WeekdaySub([Last Day],[Date Manager Entered])

 

...but I get the error message that it's "expecting date but found number."  However, both those fields are date as well as the formula.

 

So ultimately I'm looking to update below formula to calculate the number of weekdays between "Date Manager Entered" and "Last Day" as well as make the ones that come out with the answer "No" red font.


IF(
IsNull([Date Manager Entered]),"", //  if empty, then result is empty quotes. 
// else we know there us a date
ToDays([Date Manager Entered]-[Last Day]) < 5, "No", "Yes")

 

Thank you so much!

 

Regards,

 

Valerie

 



  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    Ok, try changing the field type to Formula Rich Text and try this.

    IF(
    IsNull([Date Manager Entered]),"", //  if empty, then result is empty quotes. 
    // else we know there us a date
    WeekDaySub([Last Day], [Date Manager Entered]) < 5, "<font color=red><b>No", "Yes")

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • VW's avatar
      VW
      Qrew Trainee
      3 years ago

      Hello Mark.  Thanks for this.

       

      For this formula, it's picking up the "<font color=red><b>No" and placing that in the field instead of making it red.

       

       

      Regards,

       

      Valerie

       



    • VW's avatar
      VW
      Qrew Trainee
      3 years ago

      Hi Mark,

       

      You can ignore my last message.  I changed the format to rich text.  Thank you!

       

       

      Regards,

       

      Valerie