Skip to main content
Solved

How can i combine 2 formulars? (OPEN)

  • November 19, 2019
  • 12 replies
  • 67 views

Forum|alt.badge.img

i will combine:
LEN({Long Text})
+
IF(LEN({Long Text})>280, “ :x: Over Limit”, “ :white_check_mark: Under Limit”)

The result should be: example: 150 :white_check_mark: Under Limit

Best answer by Kamille_Parks11

Put an ampersand between the two formulas. I’ll assume you want to include a space between the number and the checkmark/X so in this case you would add & " " &:

LEN({Long Text}) & " " & IF(LEN({Long Text})>280, ":x:Over Limit", ":white_check_mark:Under Limit")

12 replies

Kamille_Parks11
Forum|alt.badge.img+27

Put an ampersand between the two formulas. I’ll assume you want to include a space between the number and the checkmark/X so in this case you would add & " " &:

LEN({Long Text}) & " " & IF(LEN({Long Text})>280, ":x:Over Limit", ":white_check_mark:Under Limit")


Forum|alt.badge.img
  • Author
  • Known Participant
  • November 19, 2019

Put an ampersand between the two formulas. I’ll assume you want to include a space between the number and the checkmark/X so in this case you would add & " " &:

LEN({Long Text}) & " " & IF(LEN({Long Text})>280, ":x:Over Limit", ":white_check_mark:Under Limit")


Thanks for the fast help!


Forum|alt.badge.img
  • Author
  • Known Participant
  • November 19, 2019

second question:
IF(LEN({Brand})<50 & >2000, “ :x: ”, “ :white_check_mark: ”& " " & LEN({Brand}) )

between it? how can i do that?


Forum|alt.badge.img
  • Author
  • Known Participant
  • November 19, 2019

second question:
IF(LEN({Brand})<50 & >2000, “ :x: ”, “ :white_check_mark: ”& " " & LEN({Brand}) )

between it? how can i do that?


  • i will also mark as X when a specific word writte example: “FORBIDDEN”

Kamille_Parks11
Forum|alt.badge.img+27

second question:
IF(LEN({Brand})<50 & >2000, “ :x: ”, “ :white_check_mark: ”& " " & LEN({Brand}) )

between it? how can i do that?


Between what?

IF(FIND("Forbidden", {Field Name}),":x:")


Forum|alt.badge.img
  • Author
  • Known Participant
  • November 20, 2019

Between what?

IF(FIND("Forbidden", {Field Name}),":x:")


i mean between both values

example <50 and >100 then mark TRUE


Forum|alt.badge.img
  • Author
  • Known Participant
  • November 20, 2019

i mean between both values

example <50 and >100 then mark TRUE


IF(LEN({Description})<10, IF(LEN({Description})>20, “ :white_check_mark: ”, “ :x: to long”), “ :x: to short”)
but this dont works


Forum|alt.badge.img
  • Author
  • Known Participant
  • November 20, 2019

IF(LEN({Description})<10, IF(LEN({Description})>20, “ :white_check_mark: ”, “ :x: to long”), “ :x: to short”)
but this dont works


i found the solution, but one last question?!
How can i create a list with forbidden words?
imagine a kind of Blacklisted words: shirt, hi, hello, test1, test2

IF(FIND(“shirt”, {Description}),“Error”)


Kamille_Parks11
Forum|alt.badge.img+27

i found the solution, but one last question?!
How can i create a list with forbidden words?
imagine a kind of Blacklisted words: shirt, hi, hello, test1, test2

IF(FIND(“shirt”, {Description}),“Error”)


Your formula is pretty close:

IF(OR(FIND("shirt",{Description}),FIND("hi",{Description}),FIND("hello",{Description})),"Error")

Basically, repeat the FIND() portion of the formula within an OR() function.


Forum|alt.badge.img
  • Author
  • Known Participant
  • November 20, 2019

Your formula is pretty close:

IF(OR(FIND("shirt",{Description}),FIND("hi",{Description}),FIND("hello",{Description})),"Error")

Basically, repeat the FIND() portion of the formula within an OR() function.


but i have 123 words for my blacklist and more then one row to check, is there any easier method?
thanks!


Forum|alt.badge.img+17

but i have 123 words for my blacklist and more then one row to check, is there any easier method?
thanks!


That sounds a View to me.


Forum|alt.badge.img
  • Author
  • Known Participant
  • November 21, 2019

That sounds a View to me.


explain me that please