Incorrect values in linked cells - days count values ("PT1944H" and such)

Options

Hello,

I wonder if anyone of you dear SmartSheets Users, came up with a problem of some random (?) values popping up in cells that are linked from another sheet, in particular to pull through the project duration (in days)?

Out of a sudden we started getting "PT1944H" and "PT2088H" in some cells, where we normally should see the number of days (i.e. "108d"). When I go to the source sheet - the value being pulled is correct, but for some reason - on my destination sheet is shows the "PT...." values.

Any idea how to resolve it?


Deleting the link and replacing helps, but only temporarily ;)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!