IF Function

evanIHA · 11/29/22

Hi All,

Attempting to write a formula and running into incorrect argument errors.

If DateA is after DateB OR if DateB is after DateC then = "1"

Mike TV · 11/29/22

@evanIHA

=IF(OR(DateA@row > DateB@row, DateB@row > DateC@row), 1, 0)

Andrée Starå · 11/29/22

Hi @evanIHA

I hope you're well and safe!

Will all date columns be filled at all times, or is there another pattern to be aware of?

I'm asking because empty cells could be an issue.

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

evanIHA · 11/29/22

https://community.smartsheet.com/discussion/comment/352579#Comment_352579

Yes unfortunately dateC could and usually is blank

IF Function

Answers

Help Article Resources

Categories