# Status icon formula help

• 0
• Question
• Updated 2 years ago
I need help generating a formula for a status field I am trying to create. Here is what I would like to accomplish...

Here is the base line for my formula - however I do not know how to write it correctly...

If the [PROJECT ID-Percent Complete] is equal to 0 and is task is assigned to Michelle, display src=\"https://images.quickbase.com/si/16/228-rect_green.png\">",

If the [PROJECT ID-Percent Complete] is equal to 0 and is assigned to anyone but michelle, display src=\"\"" rel="nofollow" target="_blank" title="Link https//imagesquickbasecom/si/16/227-rect_redpng">https://images.quickbase.com/si/16/227-rect_red.png\">",

If the [PROJECT ID-Percent Complete] is equal to 25 and is assigned to Danya, display src=\"\"" rel="nofollow" target="_blank" title="Link https//imagesquickbasecom/si/16/227-rect_redpng">https://images.quickbase.com/si/16/228-rect_green.png\">",

If the [PROJECT ID-Percent Complete] is equal to 25 and is assigned to anyone but Danya, display src=\"\"" rel="nofollow" target="_blank" title="Link https//imagesquickbasecom/si/16/227-rect_redpng">https://images.quickbase.com/si/16/227-rect_red.png\">";

If the [PROJECT ID-Percent Complete] is equal to 50 and is assigned to John, display src=\"https://images.quickbase.com/si/16/228-rect_green.png\">",

If the [PROJECT ID-Percent Complete] is equal to 50 and is assigned to anyone but John, display src=\"https://images.quickbase.com/si/16/227-rect_red.png\">";

If the [PROJECT ID-Percent Complete] is equal to 75 and is assigned to Bob, display src=\"https://images.quickbase.com/si/16/228-rect_green.png\">",

If the [PROJECT ID-Percent Complete] is equal to 75 and is assigned to anyone but Bob, display src=\"https://images.quickbase.com/si/16/227-rect_red.png\">"

• 896 Points

Posted 2 years ago

• 0
• 4,022 Points
This is a very complicated problem to solve that needs a bunch of setup work to get you to the point where you can create your formula.

I can show you a demo of how we've set this up for other clients (we are a Quick Base development company) if you like. Visit my profile page or www.cirrusops.com

Basically the problem is this:

Tasks are not aware of any other tasks. Even with predecessors, they only become aware of the task that falls before it; though not any real information about the task, just the record id# of it, which is not helpful in your formula.

Now, using summary fields in the relationship between projects and tasks, you can summarize info about specific tasks up to the project and then back down to all tasks with lookup fields. If you have a set list of tasks everytime, this can be done fairly easily. You can summarize whether a certain task is complete or not, even when it was completed. The other tasks related to that project can utilize that information to determine where it specifically fits into the project plan and if it is next or not. If you do not have set tasks lists, this method falls apart. In that case, we use some coding to solve the problem.

Hope that is helpful - reach out to continue the conversation.
• 896 Points

Hi Eric -

Thanks for the quick reply. Sounds complicated. The task list is the same for every project so I have that going for me. It is all copied over from a Template each time a new project is added. Even better, the users who are assigned these tasks never change. Task 1 is always "task a" assigned to "michelle" for example.

Currently, the way the report is setup to show % complete is working as is. Looking at the photo I attached, Danya will not start on a task unless % complete is equal to 25%. She knows if it shows 0%, that Michelle still needs to complete her task.  It works but is not as visually appealing and it still takes a tiny bit of thought to comprehend. Our users are 100% capable of doing this, I'm just a sucker for icons these days and thought there might be an easy way to reflect those percentages as icons so to speak.

In writing this response I may have thought of an idea. I will update if it works. :)

• 896 Points

Can anyone tell me why this formula will not work?

Case ([Project ID - Percent Complete],"0","<img src=\"\"" rel="nofollow" target="_blank" title="Link https//imagesquickbasecom/si/16/821-check_purplepng">https://images.quickbase.com/si/16/821-check_purple.png\">";,

null)

Project ID - Percent Complete is a Numeric Summary. I think that might be the issue. Is there anyway to fix?

T.I.A

• 4,022 Points
Try .25, .50, .75
• 896 Points

Didn't work. Thanks for the reply though! I also tried changing it to an IF formula. no dice.

• 4,022 Points
Don't use quotes - quotes are for text
• 896 Points

SUCCESS!!! Thank you!