IF formula from Excel to Smartsheet

alys

Hi, I currently have a spreadsheet in Excel I am moving to Smartsheet with an IF formula. Can someone help translate what this formula should be in Smartsheet?

In Excel, the Current Widget Liabilities formula is: =IF((2023 Paid Widget Balance + 2024 Paid Widgets - Widgets Created in 2024) <0,0,(2023 Paid Widget Balance + 2024 Paid Widgets - Widgets Created in 2024)

Thank you!

Shanky Paul

Try the below formula in smartsheet:

=IF(([2023 Paid Widget Balance]@row + [2024 Paid Widgets]@row - [Widgets Created in 2024]@row) < 0, 0, ([2023 Paid Widget Balance]@row + [2024 Paid Widgets]@row - [Widgets Created in 2024]@row))

Paul Newcome

Try this:

MAX(0, [2023 Paid Widget Balance]@row + [2024 Paid Widgets]@row - [Widgets Created in 2024]@row)

Shanky Paul

Try the below formula in smartsheet:

=IF(([2023 Paid Widget Balance]@row + [2024 Paid Widgets]@row - [Widgets Created in 2024]@row) < 0, 0, ([2023 Paid Widget Balance]@row + [2024 Paid Widgets]@row - [Widgets Created in 2024]@row))

Paul Newcome

Try this:

MAX(0, [2023 Paid Widget Balance]@row + [2024 Paid Widgets]@row - [Widgets Created in 2024]@row)