Community

2

Hi, I want a RGY to turn Red if we are "pass" our target date,

yellow if "at" the target date, and Green if "before" our target date, 

=IF(ISBLANK([Target Date]1), "", IF([Target Date]1 > TODAY() + 1, "Green", IF([Target Date]1 >= TODAY(), "Yellow", IF([Target Date]1 < TODAY(), "Red", ""))))

this

0

Hello! we use Smartsheet mostly for inventory management and I was wondering if anyone had some suggestions on how to write a formula to automatically subtract the parts that go into each item while also subtracting the completed part. I currently link in the part inventory from one sheet and update