Best Of
Change font color of part of text in a cell
Hi
I would like to change the font color of part of the text in a cell to highlight things i would like the user to focus on. it seems when i highlight text and choose a different color, it applies my color choice to all of the text in the cell. is there a way to change only some of the text in the cell?
LorieT
Re: CONTAINS formula with contact cell
Try using Has:
=IF(HAS(Collaborateurs@row; "Frederique Goulet"); "True"; "False")
Nic Larsen
Re: Create a sheet that lists all working days in the date column
@Album This formula will cut out Saturdays and Sundays. Start by setting your first date in Row 1 manually, then below it enter:
=IF(WEEKDAY(Date1) = 6, Date1 + 3, IF(WEEKDAY(Date1) = 7, Date1 + 2, Date1 + 1))
Then just Ctrl-C/Ctrl-V this formula down through 260 or so more rows and you'll have all the week days for a year.
The logic is: If the day of the week for the date in the row above this one equals 6, aka Friday, add 3 days to that date; but if the day of the week for the date in the row above this one equals 7, aka Saturday, add 2 days to that date; otherwise, just add 1 to that date.
Jeff Reisman
Re: Modifying a custom profile field in Control Center
Isaac, thank you for the response. What you shared will not help solving my question. I am looking to change the profile field data name as it is assigned in the blueprint. I ended up adding a new data field and populated the existing projects with a formula pulling from the original field, new projects going forward would be set up correctly.
MarkCep
Re: [GIVEAWAY CLOSED] [RECAP] Jumpstart 2025: Celebrating Community + BONUS chance to win swag!
- Newsletter recognition
- Fireworks (but for milestones)
Brooke Y
Re: Introducing the newest Community Champions! π [January 2025]
Congratulations to all of the new Champions, and thanks for the amount of time that you all spend helping the community. I'm always impressed by how low the number of "unanswered questions" is.
And thank you @Protonsponge for stress testing that feature! I never thought to test it out on that many columns lol.
SSFeatures
Re: Data Table Functionality -- LookUp Mode not asking for Unique Identifier
Hi @swfascetti!
After researching, this behavior has been noticed before in a few cases but appears to be very sporadic. A recommended approach to avoid this issue is to allow some time before selecting the Lookup Mode option when connecting to a Data Table.
If the issue persists after trying this, itβs best to reach out toΒ Smartsheet SupportΒ so they can troubleshoot further through a private channel.
I hope this helps!
Cheers,
Isaac.
Isaac A.
Re: Copying Columns
Thank you Ray. I will upvote the one above and create a new enhancement request.
Felicia Nabors