"Late Timesheet" Formula not working

Topic Labels: Formulas
419 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Our staff are supposed to submit their timesheets for the previous day before 8:00AM. Some of them are not turning them in on time, and I would like to have a formula result that shows "Late Timesheet" when the sheet is submit TODAY() after 8:00AM. I have a formula set to just show the Submission Hour (eg. Created = 4/6/2023 7:07AM; Submission Hour = 7). I have tried several variations of the following:

IF(AND({Created}=TODAY(), {Submission Hour}>7),
     "Late Timesheet",

No matter the condition of the timesheet, the result is always blank. Thanks in advance!

1 Reply 1

Weird, this seems to work fine.  Could you create an example base and provide a link to it so that I can check it out for you?  There's probably some weird interaction that is hard to diagnose without looking at the base directly

Feel free to DM me an invite link directly if you'd like

Screenshot 2023-04-07 at 5.43.36 PM.png