Nested "if" formula

LSI Craig

I'm trying to convert this excel formula to Smartsheet but can't find the right procedure. Keeps coming back as unparseable.

=IF(J3=100%,G3,IF(J3<100,""))

J3 will always be filled in with a % and G3 is a dollar amount.

Any help is appreciated.

Craig

topazfae

You may need to reconfigure the setup since Smartseet does not have a "letter" reference. Instead, you can use the column headings.

For example, let's say the column with heading "J" represents percentages and the column G represents dollars. In this case, you can use the following formula:

=IF(Percentage@row = 1, Dollar@row,"")

The empty quotes ("") at the end are not necessary, but if you prefer to include them, you can use them when the statement evaluates to false.

I hope this explanation assists you.