Today Formula Working and not Working
Hey Folks,
I'm having trouble the column HELPER|Today & Safety Issue (Not R/Y). That column should only say "Yes" when the submission was for Today, the HELPER|Today & Staffing Level is Blank and the Safety Issues is "Yes".
The formula in that column works for the past submissions and todays submissions but is saying that a submission from yesterday (5/8/23) meets that criteria even though it does not. The formula works for all the submissions except that one and I cannot figure out why.
I pasted the Formulas below for the three columns in gray below:
• HELPER|Staffing Level - =IF(OR([Staffing Level]@row = "Red", [Staffing Level]@row = "Yellow"), "Yes", "")
• HELPER|Today & Staffing Level - =IF(AND(Submitted@row = TODAY(), [HELPER|Staffing Level]@row = "Yes"), "Yes", "")
• HELPER|Today & Safety Issue (Not R/Y) - =IF(AND(Submitted@row = TODAY(), [HELPER|Staffing Level]@row = "", [Safety Issues]@row = "Yes"), "Yes", "")
Thank you!
Answers
-
There may be a time zone issue on the back-end which has been pretty common when leveraging the system generated columns. There are a handful of posts here in the Community that have solutions for accommodating time zones. It is basically an IF statement that evaluates the time portion as a text string and says that if the hour is greater than # and "PM" is found, then adjust the date accordingly.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!