Best Of
Re: Rich Text formatting in cells
Adding my voice to this ask.
We would like to use Smartsheet to track written copy content for our projects, but the inability to have different formats of text within cells is a huge limiting factor.
We would like to put all text for a topic in a single cell. This includes titles, paragraphs, quotes, key words, etc. and requires at minimum the support of selective bold, italics, bold italics, bullet points and numbered lists. Support for multiple font sizes and selective font colour would also be an asset. We would be able to copy the text directly out of the cell and paste into another program (typically Adobe Illustrator or Indesign) to create our graphic panels.
In our use case, each text piece is assigned a tracking number in a different cell of the same row to that all our content pieces can be sorted or filtered as needed. We are typically working with a hundred or so pieces of text that are each 1-2 paragraphs in length, so a database/spreadsheet system gives us the best overview and control vs. one large word processing document (cannot sort content) or multiple small word processing documents (cannot see full picture of the project). Bonus points if another cell on the same row could house all the related images/graphics that go with the content, but that is a different ask.
LinetteOrigin
Re: Rich Text formatting in cells
I am not sure if there is another request or mention of this elsewhere but this suggestion is not only extremely relevant to text in cells but also in the comments!! Rich text formatting would be extremely helpful both in cells and in comments as there are no other real tools for note-taking in Smartsheet.
I know this request is on the roadmap, glad to hear it and looking forward to what comes of it!
jmillercvlav
Re: Formula - Helper Column Flag if Duplicate
Hi @Estephania,
The original formula provided by @Andrée Starå works with the addition of a "=" in the COUNTIF condition.
=IF([Employee ID]@row <> "", IF(COUNTIF([Employee ID]:[Employee ID], =[Employee ID]@row) > 1, 1))
FYI...the "=" is also needed if you use the formula provided by @Eric Law (at least in my testing).
=IF(COUNTIF([Employee ID]:[Employee ID], =[Employee ID]@row) > 1, 1, 0)
Hope this helps,
Dave
DKazatsky2
Re: Formula - Helper Column Flag if Duplicate
Hi @Estephania
I hope you're well and safe!
Here's an example of how it can be structured. This will show all duplicates (the original and the duplicate(s)).
Add the formula to a so-called helper column (Checkbox), and update the column name to match yours.
=IF(ColumnName@row <> "", IF(COUNTIF(ColumnName:ColumnName, ColumnName@row) > 1, 1))
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
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: countifs and a date that falls between two dates
The first formula is missing a comma before "<=TODAY())"
John C Murray
Re: Share Data Shuttle Workflows
@Kleerfyre That's a good point! It's not as straightforward as it could be, but if I look at a sheet's activity log and see that a coworker has modified a dropdown list at 2am every day, that's a pretty good sign that they are updating it via Data Shuttle.
Julie Fortney
Re: Bring back value based on a value in another cell
Hey @mahmadi
Using <> "No" is exactly what I would have suggested:
=JOIN(COLLECT({Special Care Items}, camp@row:Fleet@row, @cell <> "No"), ", ")
If this isn't working, can you post a screen capture of how the reference sheet is set up?
Thanks,
Genevieve
Genevieve P.
Re: How to delete rows automatically
Below is a manual workaround I use to get a notification when a sheet is getting full.
In the Sheet Summary of the “trash” sheet, I have 3 fields, Total Columns, Total Rows and Total Cells (which is Total Columns*Total Rows). On the first row of the sheet, I add an INFO row with specific data that I can reference in automation and the Total Cells (=[Total Cells]#) in another cell. (I color that row orange.)
This allows me to setup automation that runs Every Day at a specific time and sends me a notice when the Total Cells is >350000. I manually delete all the rows because we don’t need them, but I don’t have to think about it until I get notified.
On my notification row, I’m using the cells that are in the sheet – I didn’t create any extra columns:
I know its not automated, but perhaps it will help you.
It can take a while to delete so I usually open it in a new window and let it do its thing while I move on.
Some folks want to keep everything - in that case I make a copy of my Move sheet for posterity and then delete the data.
ker9
Re: Why is my destination sheet not showing for copying a row in a workflow?
Thank you for confirming that you see the desired sheet!
Yes, the sheet picker was updated recently. The pop-up window is a window to Search in, versus immediately displaying sheets in your account. Here's the release note:
Cheers,
Genevieve
Genevieve P.
Sheet Templates
I'm new to the Smartsheet Planning group for our team so I'm coming in after years of them doing things a certain way. I'm trying to find a more efficient manner to manage updates to master sheets instead of rolling them out quarterly as we've been doing. Essentially every quarter we pull all feedback, make updates to the primary sheets we have, then the team uses the new version for any new projects going forward. This doesn't seem like the most efficient way to do this.
Right now we make multiple copies of a particular sheet and team members rename one of the copies for their project. The problem with this is if we find an error or an update we'd like to make to the master as we are working through our project, we can't push out updates to all sheets that are already being used. This means everyone is not potentially using the same version of the sheet.
I'm wondering if there is a way that if we need to make updates to the main sheet is there a way to get those updates to flow to all sheets being used. Would creating a template and people creating a sheet using the template work like this? Essentially making the sheets being used dynamic and up to date with all corrections/updates to the master template.
Eagle