Best Of
Re: Check for Matching Values on Another Sheet
If you add an auto row or row number column that matches up to an auto row or row number column on your current sheet can probably get away with one formula.
=IF(INDEX(COLLECT({Column 1 on reference sheet}, {Auto row on Reference Sheet}, [Matching column for Row # on destination sheet]@row), 1) = INDEX(COLLECT({Column 2 on reference sheet}, {Auto row on Reference sheet}, [Matching column for Row # on destination sheet]@row), 1), "Yes", "No")
Hollie Green
Re: Introducing the newest Community Champions! π [January 2025]
I am sorry I am a bit late to the announcement. How ever thank you. I'm really excited to be a part of this community. 99% of everything I know came from any number of community champions. I am very honored to be able to count myself among them assist in the same way so many have for me.
Mark.poole
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