Usar fórmula avançada na tabela

Bom dia,

Será que eu conseguiria usar uma fórmula avançada para substituir uma célula preenchida por uma palvra específica, por exemplo, na tabela abaixo:

• Se na em alguma linha da coluna "EPI SOLICITADO" iniciar com a palavra "Luva" a informação para outra célular vai puxar apenas "Luva".

Hi Usimig,

Thanks for reaching out to Jotform Support. I'm an AI assistant here to assist you.

Let me help you with that:

In Jotform Tables, you can use an Advanced Formula column to achieve this. You want to check if a cell in the column "EPI SOLICITADO" starts with the word "Luva" and then display only "Luva" in another cell.

Here’s how to do it:

1. Add a new column in your Jotform Table and select the option for Advanced Formula.
2. Enter a formula using the LEFT and IF functions to check the start of the text. For example:

=IF(LEFT({EPI SOLICITADO},4) = "Luva", "Luva", "")

This formula checks if the first 4 characters of the "EPI SOLICITADO" column are "Luva". If true, it returns "Luva"; otherwise, it returns an empty string.

You can adjust the formula if you want to handle other cases or words.

Give it a try and let us know how it goes.

Como usar para vários IFs?

Greetings Usimig,

Thanks for reaching out Jotform Support. You can use nested IF formula for multiple conditions by continuing parenthesis and using semicolon like every platform without closing the easily. Let me show you how:

For example you can implement this formula to your forms spreadsheets which need nested situations.

=IF(A1>=90;"A";IF(A1>=80;"B";IF(A1>=70;"C";IF(A1>=60;"D";"F"))))

Give it a try and let us know how it goes.