6 - Interface Innovator
since ‎May 16, 2022
‎May 18, 2023

## User Statistics

• 15 Posts
• 0 Solutions
• 6 Kudos given

## Formula IF statement pulls data from a specific row + cell

Hi,Not sure if this is possible...I'm looking to create a formula that checks the condition of a single select cell called {Alt Shop}. IF empty use {Discount Code} if it contains "Shop Name" to use data from a particular cell in a particular row.For ...

## SUM of values separated by commas in the same cell ,

Hi, Is there ANY solution to adding numbers separated by commas in the same cell? I have used the SUBSTITUTE function to replace multi-select items with a numerical value and this has resulted in this kind of result: 3,2,1,4,1 Now I need to add those...

## IF, ELSE, OR in Formulas

Hi, This is my current formula for an If not blank > do this OR if blank > do this: IF({Discount}, {Brand} & " Discount Code: " & {Discount} &" off -", IF(NOT(Discount), {Brand}))& " "&{Product Title} But I would like to add another option that if {...

## HELP! Formatting Decimals in Formulas

I am trying to format decimals in a formula to no avail: To the left is the numberthe 3rd column is what happens when this number is used in a formula (the end is cut off for numbers ending in 0) (e.g. 12.50 > £12.5middle column is where I have form...

## Decimal places being removed in formula + Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date

Hi, I am using this formula and it isn’t implementing the decimal places from my {Refill / lowest price} column, which in itself is set to 2 decimal places: "Lowest cost per " & {Unit} & " based on: " & “£” & {Refill / lowest price} & " for "& {Lowes...
Kudos from
Kudos given to