I am trying to develop a formula to flag tasks that are less than 50% complete but more than 50% of the duration has passed. I'm not sure if my math is correct. But aside from that, can Smartsheet perform functions like the one I am proposing below? Currently, it returns an unparseable error. If I get this formula to work, I would incorporate the checked box in that column into another formula.
=IF(((([End Date]@row – TODAY())/[Duration]@row)< 0.5), 1, 0)