Forum Discussion
ajitsahoo8338
Helper III
Helper IIINeed help with this logic
Hello Everyone, I am trying to create logic but failed to do. I need to create a Status Column. In which there should be rows/options i.e "On-Time", "Late", "Released" "On-Time"= NOT(ISBLANK(Pr...
Kedar_Pande
Super User
Super Userajitsahoo8338 You can try:
Status =
SWITCH(
TRUE(),
NOT(ISBLANK(Project_v2_w_LW_PPC[Release Date])), "Released",
NOT(ISBLANK(Project_v2_w_LW_PPC[Release Date])) && Project_v2_w_LW_PPC[Release Date] <= Project_v2_w_LW_PPC[Baseline_EndDate], "On-Time",
(
ISBLANK(Project_v2_w_LW_PPC[Release Date]) && Project_v2_w_LW_PPC[Baseline_EndDate] < TODAY()
) ||
(
NOT(ISBLANK(Project_v2_w_LW_PPC[Release Date])) && Project_v2_w_LW_PPC[Release Date] > Project_v2_w_LW_PPC[Baseline_EndDate]
), "Late",
BLANK()
)
This structure ensures each row fits into exactly one category without overlap.
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
ajitsahoo8338Helper III
Helper IIIHello Kedar_Pande This is not working