Greater Than But Less Than Formula For Time
I'm trying to build a formula that looks at times in two columns to see if it spans two dates aka starts before midnight and ends after midnight but my formula isn't working. Any suggestions to correct my formula or to write it differently?
=IF(And([Approved event start time]@row>= 12:00 AM, [Approved event end time]@row<= 12:00 PM], "Yes")
Answers
-
Smartsheet is unable to calculate time directly. Here is a thread with a lot of time based formulas. You should be able to grab something from there and tweak it.
-
The easiest solution would be to add the date to the column and reference the date instead of the time.
=If(DATE[approved event start time]@row=DATE[Approved event end time]@row,"Yes")
If you can't then you will need to create some helper columns to develop your if formula.
See https://community.smartsheet.com/discussion/65268/change-time-into-military for how to convert to military time
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!