Forum Discussion

ChristianAU's avatar
ChristianAU
Frequent Visitor
2 years ago
Solved

Custom variable 'Status' and custom variable 'p'

I wanna make a new variable called 'status' and one called 'p'. The purpose for this, is to be able to make a response rate.    The formula should be something like this: 1. Custom column 'status'...
Need Help
  • Elcin_7's avatar
    Elcin_7
    2 years ago

    Hi,

    From the ribbon Add Column - Conditional Column- fill the relevent area as below.

     

    Choose for cloumn name - task status cloumn

    Operator -equal

    Value - enter a value - "status" (use apostrophe because this is text )

    Then - "answered"

    Else - "not answered"

     

    The other one is same logic just dont use apostrophe because it is number.

     

     

Elcin_7's avatar
Elcin_7
Icon for Helper I rankHelper I
2 years ago

Hi,

From the ribbon Add Column - Conditional Column- fill the relevent area as below.

 

Choose for cloumn name - task status cloumn

Operator -equal

Value - enter a value - "status" (use apostrophe because this is text )

Then - "answered"

Else - "not answered"

 

The other one is same logic just dont use apostrophe because it is number.

 

 

ChristianAU's avatar
ChristianAU
Frequent Visitor
2 years ago

I totally missed the "conditional column", it made it much easier.

Your solution was the right one, however there's no need to use apostrophe.