Help

Override and reverse engineer automation?

Topic Labels: Automations
398 1
cancel
Showing results for 
Search instead for 
Did you mean: 
andrewb9
4 - Data Explorer
4 - Data Explorer

Hello! I have two fields as per this table:

Score

Likelihood

1

5%

2

20%

3

40%

4

60%

5

80%

Is it possible to type a score 1-5 in that field and return the associated percentage in the Likelihood field. Then also being able to do the reverse when needed: ie. typing in the percentage in the likelihhood field and return the associated score in the score field? 

Many thanks to anyone who might be able to help me with this. It's a puzzle for me.

Andrew

 

1 Reply 1
Sho
11 - Venus
11 - Venus

Hello @andrewb9,

The Formula field can be formatted for likelihood display if the output is number.2023-09-25 083818.png