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!

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.