HELP WITH DASHBOARD DATE MALFUNCTIONS

Lloyd Cox

Hello all, be really glad if someone can help me with overcoming a problem with some dashboards we run to track live scores in manufacture in our factories.

We use a grid view smartsheet (Production smartsheet) to schedule production, and as the items on the schedule are produced, the production team update the schedule to show the goods as completed. There is a second smartsheet (Metrics smartsheet) that takes the information from the production schedule, and collates it into a condensed form that is then dispalyed on a dashboard (scoreboard). This allows us to display real-time progress via a visual scoreboard, on how the actual production is tracking v. the scheduled production, for a day.

Unfortunately there seems to be a cell link somewhere that I cannot trace, that keeps reverting the date on the Metrics smartsheet to the previous day. The cell history just shows 'Cell Link' as the user that initiated the change.

Does anyone have any ideas on how to overcome this?

Andrée Starå

Hi @Lloyd Cox

I hope you're well and safe!

You can use the Sheet Reference Manager to find and fix the cell link.

https://help.smartsheet.com/articles/2482646-view-modify-delete-cross-sheet-references-formulas#toc-edit-in-the-reference-manager

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Lloyd Cox

Thanks Andree,

Strangely it does not show anything under cell link references... Shall see if anything shows up once the issue starts again today!

You happy if I let you know how I go?

Lloyd Cox

Screenshot 2023-04-13 092913 - CELL HISTORY.jpg

Screenshot 2023-04-13 092813 - CELL LINKS.jpg

I have put a couple of screen shots on here, to show the anomaly between what the cell history shows and what the cell links data shows.

Any further ideas??

Andrée Starå

@Lloyd Cox

I'd be happy to take a quick look.

Can you share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Lloyd Cox

I can share the production scheduling smartsheet and the metrics smartsheet that powers the dashboard, but at the moment I only have view-only to the actual dashboard - will you need all three?

Andrée Starå

@Lloyd Cox

No, I think I only need the two.

Lloyd Cox

Hello Andree, sorry for lapse in communications - just had a role change and been assigning over some tasks to another guy here....!!

Have shared them to you as Editor status

Lloyd Cox

Hello Andree,

Have you had a chance to look at this? Any clues yet?

Andrée Starå

@Lloyd Cox

Yes, I think I know what's going on.

I've sent you an email.