Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Custom Formatting on Calculated Field

Avatar

Level 2

I am trying to create a calculated TASK field which displays the planned completion date of the task, and if the status of the task is complete, the background turns green. Is this even something that can be done within the calculated field or does this formatting need to be done on the report itself? I'm open to either one, but I'm having a hard time figuring out how to make it happen either way. The report is a PROJECT report that pulls in several calculated TASK fields, which I'd then like to format to turn green when the status of the task is complete. Anyone have any tips? Thank you!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 10

I'm pretty sure formatting is only possible in a report, not in a form field. You can still do the calc field in the form and then color it in the report though.