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

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 ;)

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Exactly how are the values being pulled in? If via column formula, try converting it to a cell formula then converting it back into a column formula and saving the sheet. I would also suggest reaching out to Support directly as it sounds like you are pulling in some kind of back-end value.

Joanna Langwald

Hi, thanks for reaching out - every cell has a link put in individually, so I recon the answer is a cell formula.

I've always been posting my problems here and they were answered immediately ;) So I didn't know any other way, sorry - could you please advise, how to raise an issue with SS Support?

Paul Newcome

Here is a link to reach out to Support:

https://help.smartsheet.com/contact/smartsheetapp

john.beardmore

Did this ever get solved as I have exactly the same problem?

However the numbers are not random. All Smartsheet has done is convert days in hours.

2088H = 87days

Joanna Langwald

Wow, thank you John, this is brilliant!

No, I raised the ticket and it's been worked on.. I keep getting messages that they resolved the issue and are closing the case, but I respond: No, it's still wrong, and then they assure they keep working on it ;)

I will check today, to confirm.

What the "PT" prefix means then..? Just curios.

john.beardmore

I think PT means Pessimistic Time.

I too am linking from another sheet and the problem happened when the master sheet was changed.

There is very little on the web about this problem.

john.beardmore

I am a very basic user so this doesn't mean much to me but seems to be something to do with our problem.

https://www.smartsheet.com/sites/default/files/2022-07/IC-Slack-Time-Cheat-Sheet-11520_PDF.pdf

john.beardmore

Smartsheet help have just telephoned me and explained there was a bug in the code and it was fixed last night.

So hopefully we will experience no more issues.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.