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

Laura
Laura ✭✭✭✭✭✭
edited 05/31/17 in Archived 2017 Posts

FORMULA HELP NEEDED

(See Screenshot)

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"

EST vs ACT.png

EST vs ACT.png

Comments

This discussion has been closed.