Trouble combining two formulas with "OR"
Options
Cindy123
✭
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
-
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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!