Conditional Formatting or Automation For Time

AKalsi

Hello,

I was wondering if anyone knew of a way to do conditional formatting or automation for the following application.

We have a date/time column that time stamps when a new entry from a form is completed. This sheet is going to be used for a witness/hold point notification, and we want a requirement of 26 hours to be in place. My goal is to be able to highlight a row or cell red when it does not meet this requirement. Currently, I am only able to place individual columns for Date and Time separately that do can't corelate with each other and will not allow me to set the requirements above.

Darren Mullen

@AKalsi Does this video on using the Time() function help you any?

https://youtu.be/J2jrhCfsDy0?feature=shared

Darren Mullen

@AKalsi Does this video on using the Time() function help you any?

https://youtu.be/J2jrhCfsDy0?feature=shared

AKalsi

@Darren Mullen Thank you so much, that was exactly what I needed. Between that video and the one that played right after, I got what I needed. I pasted a link to the second video I was referencing. This was a big help!

Smartsheet Date Time Calculations: Calculating the Difference Between 2 Dates and Times

Darren Mullen

@AKalsi Great!!! Thanks for the follow up !