I’m trying to build an ITE for a range of times where I get “Morning,” “Afternoon” and “Evening” returned but I can’t get it right. I was able to implement a script in my Sheet that worked great but whenever a new row was created, it didn’t implement it - it just stayed in the row above.
I’ve tried basing it off of “If NOW is on or before then (the static time)…” as well as “If morning (based off of the static time) is on or before NOW then…” but I can’t get it. Someone please help!
If you want a dynamic greeting, then just have one now column, you can keep everything like it is. Then make an hour column like I said, and an If Then Else to generate the greeting.
Current time is 0847 and it’s been converted to a whole number using a Math column. I have the ITE column setup and, to test it, I have it setup to populate “Afternoon” after 7 but it will still only show “Morning.” What am I doing wrong?
Your IF statement stops after the first true statement. All of your numbers are greater than or equal to zero so it’s always going to return Morning as a result. Flip it around so it checks the largest number first.
@Jeff_Hager coming through in the clutch! THANK YOU! I was going to post a gif of Nacho Libre telling you that you’re the best but it won’t let me, so I’ll just say it -