Nested "if" formula

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

Tags:

Answers

  • topazfae
    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!