Discussions

Expand all | Collapse all

Formula assistance - not null

  • 1.  Formula assistance - not null

    Posted 16 days ago
    I have two fields:
    text field....[COLOR CHANGE]
    checkbox formula....[SEE CHANGE ALERT]

    Looking for result ...If the [COLOR CHANGE] field IS NOT blank, enter check mark in [SEE CHANGE ALERT] field
    thank you

    ------------------------------
    BuildPro
    ------------------------------


  • 2.  RE: Formula assistance - not null

    Posted 16 days ago
    Your checkbox formula will be:

    [Color Change]<>""

    Checkbox formulas don't require an if statement. They will be true (show a checkmark) if whatever conditions you set are satisfied.

    ------------------------------
    Michael Tamoush
    ------------------------------



  • 3.  RE: Formula assistance - not null

    Posted 16 days ago
    thank you...

    ------------------------------
    BuildPro
    ------------------------------