Best Of
Re: Is there a way to have dynamic cell updates? My previous attempts were unsuccessful.
@denkeis In addition to Data Shuttle, this can also be achieved using the premium add-on Bridge, the API, other similar third party apps, and we at 10xViz also offer a dropdown column manager to accommodate this.
Paul Newcome
Re: Introducing the Smartsheet Unlocked podcast...
I might be biased but I love this podcast, especially the first episode with Will! 🤩 Great work, Rich.
Alison C.
Re: Side-by-side fields in Forms
Field placement on forms is an important missing feature that should be given priority on the continuing development list.
PMINJ
Re: Find and replace inside a formula
Hi @userpoets
I hope you're well and safe!
Unfortunately, it's not possible now if you don't have Control Center (and the sheet is provisioned through it), but it's an excellent idea!
Here's a possible workaround or workarounds
- You could have the value either in a so-called helper column or in the Sheet Summary and reference it in the formula.
Make sense?
Would 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!
Andrée Starå
Re: Issue can't update a Delivery Date in a report, source sheet populating Delivery date with formula
@PDunn Keep the calculated date then have an override column. Update the calculated date formula to look at the override column and pull it in if it isn't blank.
This assumes you aren't trying to update a project column "end date" for a Gantt chart. If it's a project column, they can't be updated in a report. however, the duration column can….
Darren Mullen
Re: Alert someone when a row is deleted
Happy to help!
Yes, that would be ideal, and maybe that is something that could be developed.
Please submit an Enhancement Request when you have a moment
✅ Remember! 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: Are New Folders No Longer Allowed In Sheets Directory
@melissalk You can house multiple assets in a single workspace and just share the assets individually. Just because something is in a workspace doesnlt mean that you have to share the entire workspace to someone.
Paul Newcome
Re: Duplicate a sheet from the workspace left navigation bar
@Lekshmi Unnithan this is an awesome and useful release, but until the formatting, formulas, https links, sheet links, etc.. are also included in that duplication, this wont be 100% useful. However, it may be useful for those who want a similar structure and same data but with a clean slate for visability, but for me, i prefer to have everything duplicated and dump what i dont need (faster than re-adding everything back in).
😀👏Thank you for this new "LIVE DRAFT"
(DRAFT = Until everything mentioned in this Note below 👇 is added & working 😀)
Note:This initial release only duplicates sheet data. Customization options such as including or excluding attachments, comments, cell links, and other elements are not yet available but will be introduced in future updates.)
Julie Becker
Re: Blank rows added to bottom of sheet / form
Is there any update for this? These same 10 rows are in our project intake sheet and our summary sheets and is throwing off our metrics/formulas for some of our dashboards.
Re: Is there a way to ONLY display the Gantt chart in my dashboard widget?
I would like to add a related point to this thread. I am not aware of a way to display a gantt on a dashboard including the relationship between tasks and subtasks. This task/subtask view is available within the project plan sheet but not in the project plan report which must be created to source a dashboard. This would be a nice feature to consider for future enhancement.