Best Of
Re: Filling in Form to Print
Hi Charles!
I have done something similar using the "Generate Document" workflow. Assuming you have the sheet and form set up, you will need to generate a fillable PDF (or Docusign template if you plan on using them) and create a document mapping. Then set up an automation with an action block "Generate Document". This will automatically create a filled out PDF per each row that is ready to print. I included links below with Smartsheet's step-by-step processes.
< link with steps to map a fillable PDF
< link with steps on how to set up the automation
AKnight
Re: Change font color of part of text in a cell
I agree with FredS. I'm needing a solution to this issue and to see people asking for this feature since 2015 in various posts and its still not implemented is greatly disappointing.
joey_p
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
