Jotform Tables: Ability to change the background color of the cells

  • Tabitha Stalcup
    Asked on December 4, 2023 at 8:06 AM

    Why cant you also change the background color of the cell based on the output of the formula? Ex. in a risk management plan once using an advanced formula to if then risk= possibility * impact

    =IF(VALUE({22}*{23})>"19","Critical",IF(VALUE({22}*{23})>"14","High",IF(VALUE({22}*{23})>"8","Medium","Low")))

    I would like to set critical to red, high to a lighter red, med to an orange, and low to green, but because it's an advanced formula, there is no option, and because it is a calculation essentially calculated from the form and correlated to a responding table that does the computing I can't use any CSS to link the if than a response to a correlated background color?

    I really enjoy the application so far but the functionality of advanced cells being limited makes this visual PM sad :(

  • Neil JotForm Support
    Replied on December 4, 2023 at 9:01 AM

    Hi Tabitha,

    Thanks for reaching out to Jotform Support. Unfortunately, it is currently not possible to conditionally change the background color of the cells in Jotform Tables.

    While the feature you’re looking for isn’t currently available, rest assured we’re always working to add new services and features to Jotform. I've gone ahead and escalated your request to our Developers. When or if it's implemented depends on their workload, how viable it is, and how many other users request it. If there are any updates, we’ll circle back to this thread and let you know.

    Reach out again if you have any other questions.