Hyperlinks in date cells prohibiting date's usage in formulas
Hi Smartsheet Community,
I am trying to calculate the # of days, positive or negative, between two dates (depending if we're early or late compared to the date in our contract) but am running into issues when our team has added hyperlinks within date cells. You'll see below that I created a helper column to try to get around the hyperlink issue but the problem persists. The SC Actual Date Helper Column is simply =[SC Actual Date]@row. And the formula that I'm using to calculate the deviation in the days is =IF([SC Actual Date Helper]131 = "", "", [SC Actual Date Helper]131 - [SC Contract Date]131), which does work if there was never a hyperlink involved.
If anyone has figured out a solution for this I would love to know. Many, many thanks in advance!