Forum Discussion

VW's avatar
VW
Qrew Trainee
2 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
VW's avatar
VW
Qrew Trainee

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
Qrew Champion
2 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
    2 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
    2 years ago

    Hi Mark,

     

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

     

     

    Regards,

     

    Valerie