How to use formulated columns in structure board.

siddharth gupta_9vgdsh

I'm trying to add a column for Risk to highlight the projects which are at risk as deadline is nearing and they are not meeting 75% completion criteria.

 

So we have quarterly projects, considering 33% plus completion is not at risk for the 1st month and similarly 66% completion for 2nd month and same as 75%  and above for third month.

I'm trying to implement a simple formula of putting above scenario in the last month of quarter using this formula.

if Progress < 75% then "Risk" else "Not at Risk"

however I'm getting an error.

Stepan Kholodov

Hello @siddharth gupta 

If the Formula column's condition is based on the progress column, then a formula like this:

if progress < 0.75 : "Risk" else "Not at Risk"

should work. Just make sure that the progress variable is mapped to the progress column. If it's showing in red in the formula then you need to click on it in the list of Used variables underneath the formula itself and select the Progress column on the dropdown list.


I hope this helps. If you need further assistance or have other questions about Structure - please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)