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.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!