Can someone help point me in the direction of doing the project condition field? Is this an image or a formula? Looking to set this up to add the health of a project into a report and the only instructions I could find was around color coding the field. Thank you!
It's a rich-text formula field. The little squares are just images you can find here: https://login.quickbase.com/db/bcgnn27bx?a=q&qid=7 or from any other host.
Depending on your what project condition is controlled by, such as a status field, you just use an If statement to control something like this:
If(
[Project Status] = "Late", "<img src="https://login.quickbase.com/up/bcgnn27bx/g/rdi/eh/va/227-rect_red.png\">",
[Project Status] = "On-Time", "<img src="https://login.quickbase.com/up/bcgnn27bx/g/rdk/eh/va/229-rect_yellow.png\">",
[Project Status] = "Completed", "<img src="https://login.quickbase.com/up/bcgnn27bx/g/rdj/eh/va/228-rect_green.png\">"
)
------------------------------
Jeff Peterson
------------------------------
Hi Jeff,
Thank you
Glad it works for you!
Hi Jeff,
Thank you for responding, but for some reason the actual image I'm looking for doesn't come up when I enter the formula. It shows the image below. Any ideas? Thank you
Qrew LegendPlease copy paste and post your formula.
