Trouble combining two formulas with "OR"

Cindy123
Cindy123
edited 03/27/23 in Formulas and Functions

I have the following two working formulas but when I try combining it I keep getting error messages.

=IF(ISDATE([Meeting scheduled date]@row), "Scheduled")

=IF(OR(Acuity@row = "High", Acuity@row = "Medium"), "Required")

They each work on its own by referencing two diff columns.

I need help combining this to one formula.

Thanks!

Answers

  • Peggy Parchert
    Peggy Parchert ✭✭✭✭✭✭

    @Cindy123

    Hello. To confirm I understand what you want.

    If the column, Meeting scheduled date, is a date - the response should be "Scheduled" regardless of what the column, Acuity shows? Or are you wanting two both responses to show?

    Thanks,

    Peggy

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!