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...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendtry 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
------------------------------
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
------------------------------
Thank you! This seems to be working.
What would be the formula to highlight the "no" answers to red? I already have 3 formulas for this report so I'm wondering if the conditional formatting can be built into the same formula as the one you've already helped me with.
Thank you!
Regards,
Valerie