Nested OR statement with Workday function


I have two columns that populate dates, if one has a date in it the other one is empty. I'm trying to develop a formula that looks at both columns and returns the day of the week.

=IF(OR(WEEKDAY([Meeting Date]@row) = 2, WEEKDAY([Due Date]@row) = 2), "Monday", "") and I'm getting an #INVALIDDATATYPE error message. I've worked the formulas by themselves and they work but the minute I combine them it populates the error.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!