Try:
IF(
AND(
{Meeting Start Date},
{Program Date}
),
IF(
AND(
DATETIME_FORMAT({Meeting Start Date}, "YYYYMMDD") = "20221101",
DATETIME_FORMAT({Program Date}, "YYYYMMDD") = "20221201"
),
"NA",
IF(
{Program Date} > TODAY(),
"upcoming",
IF(
NOT({Program Date}),
"ToDo",
"done"
))))
Try:
IF(
AND(
{Meeting Start Date},
{Program Date}
),
IF(
AND(
DATETIME_FORMAT({Meeting Start Date}, "YYYYMMDD") = "20221101",
DATETIME_FORMAT({Program Date}, "YYYYMMDD") = "20221201"
),
"NA",
IF(
{Program Date} > TODAY(),
"upcoming",
IF(
NOT({Program Date}),
"ToDo",
"done"
))))
Yes, that worked! Thank you. Wendy
Yes, that worked! Thank you. Wendy
If my result is “done” It has to be verified first. I have another field called MtgDone which requires HR’s checkmark for the employee to get credit. Is there a way to add that into this function?
If my result is “done” It has to be verified first. I have another field called MtgDone which requires HR’s checkmark for the employee to get credit. Is there a way to add that into this function?
IF(
AND(
{Meeting Start Date},
{Program Date}
),
IF(
AND(
DATETIME_FORMAT({Meeting Start Date}, "YYYYMMDD") = "20221101",
DATETIME_FORMAT({Program Date}, "YYYYMMDD") = "20221201"
),
"NA",
IF(
{Program Date} > TODAY(),
"upcoming",
IF(
NOT({Program Date}),
"ToDo",
IF(
{MtgDone},
"done",
"needs verification"
)))))
IF(
AND(
{Meeting Start Date},
{Program Date}
),
IF(
AND(
DATETIME_FORMAT({Meeting Start Date}, "YYYYMMDD") = "20221101",
DATETIME_FORMAT({Program Date}, "YYYYMMDD") = "20221201"
),
"NA",
IF(
{Program Date} > TODAY(),
"upcoming",
IF(
NOT({Program Date}),
"ToDo",
IF(
{MtgDone},
"done",
"needs verification"
)))))
Wow! That works. Thank you. I appreciate all the help. Wendy
Wow! That works. Thank you. I appreciate all the help. Wendy
Good, please mark my second reply as the solution to close this thread.
Hi, Kamille. I need a tweak to get the NA to work. For example, an employee isn’t required to complete a program until 12/1/2022. In the November program field he needs an NA. The formula is returning a missed (but with my emojis). Here is my formula with my fields. I may not understand your NA formula and the meaning of the dates in “”.
IF(
AND(
{Meeting Start Date},
{NovBeg(hide)}
),
IF(
AND(
DATETIME_FORMAT({Meeting Start Date}, “YYYYMMDD”) = “20221101”,
** DATETIME_FORMAT({NovBeg(hide)}, “YYYYMMDD”) = “20221101”**
),
“NA”,
IF(
{NovBeg(hide)} > TODAY(),
“upcoming”,
IF(
NOT({Nov22}),
“ 
”,
IF(
{Nov22}=“Nov 2022”,
“ 
”,
“ ”
)))))
