Project Condition
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 inst...
Forum Discussion
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
------------------------------
Val Wong
------------------------------Glad it works for you!
------------------------------
Jeff Peterson
------------------------------
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
------------------------------
VW
------------------------------Please copy paste and post your formula.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------Hi Mark,
Apologies. I tried to delete my comment, but I guess it didn't work. I was able to mess around with the formula to get it to work. Thanks for following up.
------------------------------
Val Wong
------------------------------
