Using IF statement to create a button based on stage level 1-8
Our company currently uses stages to determine what needs to be done on a particular job. I currently have a Text-Multichoice field that allows a user to select which stage the job is currently on when they update the form and then it displays this choice on the report.
I would like to set this up as a Formula-Rich Text field that displays a colored button based on the stage the user selects when editing the form.
example:
Stage 1 = Blue Button
Stage 2 = Green Button
Stage 3 = Yellow Button
Stage 4 = Red Button
etc.
Can anyone assist with writing up a IF statement I can go off of?
I would like to set this up as a Formula-Rich Text field that displays a colored button based on the stage the user selects when editing the form.
example:
Stage 1 = Blue Button
Stage 2 = Green Button
Stage 3 = Yellow Button
Stage 4 = Red Button
etc.
Can anyone assist with writing up a IF statement I can go off of?
