Clocking In / Out

McAfee Electric Mgr

I am trying to create a formula where if a Green Circle symbol drop down is chosen, then it records the time from the Date Modified Column. I keep getting invalid data type. Can someone tell me where the error is in this formula?

=IF([Clock In ]@row, "Yes", TIME(RIGHT([Date Modified]@row, 8)))

dojones

Try this.

=IF([Clock In]@row = "Yes", TIME(RIGHT([Date Modified]@row, 8), 0))

McAfee Electric Mgr

It didn't create an error, but it left a blank cell.

Andrée Starå

https://community.smartsheet.com/discussion/128213/clocking-in-out

Hi,

I hope you're well and safe!

Try something like this.

=IF([Clock In]@row = "Green", TIME(RIGHT([Date Modified]@row, 8), 0)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

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

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!