My Formula looks incorrect


I am attempting to get a Margin (%) for my outcome, however I have received "unparseable", "incorrect argument" "invalid" when attempting a few variations. Am I overlooking something?

I need to get my

The formula I am using in smartsheet:

=IF(ISBLANK([Customer Cost/Booking $$]@row - [Partner Cost $$]@row), "", /[Customer Cost/Booking $$])

So that the outcome would be in the margin column:

Thank you!!



Best Answer


  • J Tech
    J Tech ✭✭✭✭✭

    Try this one

    =IF([Customer Cost/Booking $$]@row="","",([Customer Cost/Booking $$]@row - [Partner Cost $$]@row), "", /[Customer Cost/Booking $$])


    J Tech

    If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
  • Adriane Price
    Adriane Price ✭✭✭✭✭✭
    Answer ✓

    Thank you, the below formula ended up working for my situation

    =IFERROR(SUM([Customer Cost/Booking $$]@row - [Partner Cost $$]@row) / [Customer Cost/Booking $$]@row, 0)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!