Need help with Calculated field expression | Community
Skip to main content
M
MariaCr2
Level 3
February 18, 2025
Question

Need help with Calculated field expression

  • February 18, 2025
  • 1 reply
  • 329 views

Hi! 

We have a field on our custom forms asking which quarter a project is planned to be competed in (Q1, Q2, etc.). The field name is {DE:What quarter was this project planned to be completed within the quarterly plan?}. I need to compare this field to when the project is actually completed (so if a project closes out anytime between January 1 and March 31, it would be completed in Q1). Field name: {actualCompletionDate}.

I need guidance on how to even start approaching this calculation in Workfront. If anyone has thoughts, I would really appreciate it. 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

lgaertner
lgaertner
Level 9
February 19, 2025

Hello,

 

You could do this:

IF(CONCAT("Q",CEIL(MONTH(CLEARTIME({actualCompletionDate}))/3))={DE:What quarter was this project planned to be completed within the quarterly plan?},"equal","unequal")

 

Does this help?

Regards

Lars

Terms & ConditionsAccessibility statement

Loading footer...