Best Of
Re: Is there a way to have dynamic cell updates? My previous attempts were unsuccessful.
Hi,
I hope you're well and safe!
You would need the Premium App, Data Shuttle, or similar.
More info:
Is that an option?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Smartsheet Expert Consultant & Partner / 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: 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.
Kam114