Best Of
Re: Cross sheet references not updating
I am having the same issue, in what I've noticed is now in 2 separate Workspaces. It would take me a solid month of working straight to add the 'today helper' record date automation to each sheet that has cross sheet formulas, not realistic.
This is drastically impacting business / day-to-day operations.
Putting in a support ticket now, but that's been just about useless in the past. If anyone else is experiencing the same issues, please comment here and vote this post up to get some attention and get SS engineering to look at it.
Kayla
Re: Date Formats in automated emails
we have exactly the same problem in Belgium and in Romania. in the automated email alerts the date format is USA. and this is independent from your personal settings ( all our personal settings are european, but in the automated emails the date is standard shown as USA format)
HVDdelta
Re: Set a Min-Max for Axis on Charts
+1 to this one. It would be really helpful to be able to set min/max values for all Dashboard charts with vertical axis or even possible to restrict the axis values only to whole numbers.
I have some metrics with % results and the axis shows up to 120% when logical maximum for those metrics is 100%. It then leads to difficulties in reading the results and questions from the leadership team.
Or cases where the result can be only whole number but it is very low number (0 or 1) - then the axis is showing scale from 0.0 to 1.2 in increments of 0.2 which doesn't make logical sense and again leads to confusion and questions why the chart is like this.
I really love Smartsheet Dashboards but impossibility to format this is impacting the impression about the product from our stakeholders (to reply it is not possible to adjust the chart axis range makes everyone surprised).
Jan Sembera
Re: Insert image to cell in batch
I'm looking to do this as well - anyone familiar with doing it through the Smartsheet API?
LaurenLong
Re: combining two smartsheets into one new
Hi,
I hope you're well and safe!
Yes, you could use a Report or cross-sheet formulas and connect the two sheets to one another.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me 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! I appreciate it, thanks!
Andrée Starå
Re: combining two smartsheets into one new
Cross-sheet formulas (Index/collect, etc) and/or Cell-Linking would allow you to have both sheets in one sheet. These will not be editable. Hope this helps.
Adam Murphy
Enhancement Requests
- In dashboard, allow the option to freeze a widget so that it is visible while scrolling up and down.
- In report view, allow conditional formatting (not available), and highlight changes (available) to be shown on dashboard view.
- Allow for the embedded link of calendar view to zoom to the calendar only on dashboard instead of the entire browser
haileypaz
Re: #REF on formulas
I'm getting this issue 3 years later. Intermittently, working formulas in some auxiliary sheet all, suddenly, display #REF. Refreshing the page, navigating away, or sometimes just staring at it in frustration for a minute cause them to resolve. However, sometimes, pages that rely on the auxiliary pages retain a #REF until you navigate to them, then back to the working auxiliary sheet, then back to them - REALLY frustrating for the users.
Eric Helal
Re: Anyone else experiencing EXTREME delays with cell linking?
Yes. the information needs to get send back to Smartsheet servers.
You need to save, then refresh to send the cell link request back .
Lately this is taking up to 15 minutes.
I have already put in a support ticket, but I'm wondering if this is affecting other users.
itsnotbroken