Best Of
Re: Welcome to the Project Management Office (PMO) Community!
For a project manager in a world of donuts and coffee, Smartsheet is a lifesaver for tracking and planning remodels. All the data is organized ans easily accessible for our tream, even on an Iphone. I`m always seeking ways to improve, and it would be nice to connect with a community of like-minded professionals.
Olena
Re: Sheet Reference Manager panel - drag to expand the window
Problem: The "Sheet Reference Manager" cuts off sheet reference names that are more than 19 characters (at least on my screen).
Idea: Allow resizing of the name column so we can view the whole sheet reference name, instead of having to press "Edit" and wait a long time for it to load.
NeilKY
Re: Ability to paste a screenshot directly into Conversations > Comments or Attachments
If we are unable to copy-paste images/screenshots into the conversations, we are losing out! It is cumbersome to download every file, every time it needs to be accessed.
Rakshit
Re: Are New Folders No Longer Allowed In Sheets Directory
I found a work around to this. Right click on workspaces and create a new workspaces. Then move whatever projects you want into that workspace and you can create folders etc.. again just like before
leroy_sd
Re: Report data not visible to those with access
I'm seeing lots of weird bugs lately too. Creating sheets, then it says I don't have access… getting a lot of "Can'r reach Smartsheet right now" and stuff like that ha
Darren Mullen
Re: May Question of the Month - Join the conversation and receive a badge
Imagine you have a big box of toys, and you want to make sure everyone gets the toy they like the most. As a Business Analyst, my job is kind of like that! I help people figure out what they need and how to make things work better. I look at all the toys (or information) and decide the best way to share them so everyone is happy and things run smoothly. 😊
Ray Lindstrom
Re: Lag between data in source and dashboard charts
So what happens sometimes is that unless you open the sheet or have it make a call on the Smartsheet servers to update the information inside. I force this to happen is with an automation to record a date in a column called "Helper Date Column". I record an initial value in the column at the top.
To create this workflow:
- Create a column called "Helper Date Column."
- Record an initial value at the top (today's date).
- Select Automation > Create workflow from scratch.
- Title your workflow (for example, "Daily Update").
- Set the trigger to When a date is reached.
- Click on Run Once and change this to Custom > Repeat every Day.
- Select an early morning time for the trigger (e.g. 2:00AM).
- Configure a condition block for where the new date column is in the past.
- Set the Action block to Record a date in that new date column.
This should successfully update the sheet daily and pull all of the updated information into the sheet, which in turn will update the reports and dashboard. Hope this helps!
Re: Lag between data in source and dashboard charts
Hi,
I have a similar problem but a much longer lag. I made a dashboard with several charts on it. Each chart is made from a report, which is sourced from a metrics sheet with not-so-complex formulas…Our employees enter data through forms, and the charts are generated automatically. The last piece of data is entered at 9 PM on a Sunday. I opened the dashboard, printed a PDF and shared it with my supervisors only to realize 3 out of 6 charts weren't up to date.
Then I had to manually open all of the metrics sheets that weren't updating automatically, and only once I opened them did they refresh…Most of the data for those metrics sheets were entered hours before, only one piece of information was entered at 9 PM. I was doing this around 9:40 PM when it was refreshing in front of my eyes when I was opening the metrics sheets.
Is this normal or do I have too many formulas going on?
Thanks
Primoz
Re: Index Match Row Number Update
@Jeff Reisman it's just part of a larger analysis that I will be doing in this new sheet, I will be setting up automated workflows which aren't supported in reports, and I cannot link cells from a report.
Kaykay
Re: Formula to flag required approvals and if they've been obtained
@Lauren Lederle When you are using @row you do not need to hyphen. As the range is literally the column in the same row your looking at. You only need to column:column if you are searching the entire column for some information
Mark.poole