IF/THEN features when building formulas

Feature Requests
1

Perhaps it is there and I am not aware of it, but it would be nice if I could put some simple logic to an formula. If {field1} = 1 then Result = "ABC" (or Result = "{field2) - you get the idea).

2

Hi,

The article that provides more detailed information about conditional equations can be found at the following URL: https://support.knack.com/hc/en-us/articles/226583228-Equations#conditional-equations

Hopefully this helps.

Best regards,

Micah :-)

3

Yes this would be useful. Also, these are available as fields, but I'd often just want to make them in table results such as Pivot tables that would dynamically reach to the data in the table, not just display formula results from the objects

I don't know if Daniel's formula above works, but I'd really want more calculations to work in Excel's format since that's what I imagine most people are used to working with

4

Is their some training or documentation on how to write formulas?  Thanks

 

 

5

Thanks Dan. Good info. I'll give it a try. 

6

Hi,

You can use basic condition syntax as below I believe:

{field_1} > 1 ? ABC : {Field_2}

 

So this gives "If field_1 is greater than 1 = ABC else = Field 2

Not tested so may need '' around the text.

 

Thanks

Dan