Conditional Formatting or Automation For Time
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.
Best Answer
-
@AKalsi Does this video on using the Time() function help you any?
Darren Mullen, Author of: Smartsheet Architecture Solutions
Get my 7 Smartsheet tips here
Take your Smartsheet knowledge to the next level and become an expert. Join the Smartsheet Guru Elite
Answers
-
@AKalsi Does this video on using the Time() function help you any?
Darren Mullen, Author of: Smartsheet Architecture Solutions
Get my 7 Smartsheet tips here
Take your Smartsheet knowledge to the next level and become an expert. Join the Smartsheet Guru Elite
-
@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
-
@AKalsi Great!!! Thanks for the follow up !
Darren Mullen, Author of: Smartsheet Architecture Solutions
Get my 7 Smartsheet tips here
Take your Smartsheet knowledge to the next level and become an expert. Join the Smartsheet Guru Elite
Help Article Resources
Categories
Check out the Formula Handbook template!