Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
FORMULA - Estimated vs Actual Time
FORMULA HELP NEEDED
I need help creating a formula to show:
IF "Actual Time" Column is 10% more than "Estimated Time" Column, then "ERP vs ACTUAL" Column shows "DOWN" Symbol
IF Not, shows "UP" Symbol.
Times are entered in minutes (00.00)
Thanks in advance!
This is what I currently have:
=IF(AND([Actual Time]1 > [ERP Time]1 * 1.1), "Down", "Up")
It works for the most part BUT it doesnt show the "down" symbol if the "Actual Time" is exactly 10% greater than "ERP Time"