Best Of
Re: SharePoint embed in WorkApps
I second this, I was very disappointed to attempt and learn that it was not achievable. Based on a segment at the Smartsheet Engage conference, one of the best ways to implement Smartsheet is to allow our users to use the tool without knowing they are in a separate system. This makes it a challenge to publish something such as a Word Document (published in SharePoint) or even a SharePoint site. I am using WorkApps for a project plan and I need full integration of the tools.
Desiree.Gonzalez
Re: Index IF formula for data in Row bases on Column data
Hello @Marielitos
If you're going through the path of using formulas, you'll need to create the formula on each column on your destination sheet. Also, I think you'd want to use INDEX/COLLECT functions instead of the INDEX/MATCH since you have the criteria of Yes/No.
So something like this for every column:
=INDEX(COLLECT({Column X},{Unique Identifier},[Unique Identifier]@row,{YES/NO Column},"Yes"),1)
Another easier way is just to do the automation and copy the row when the Yes/No column is equal to "Yes". Formulas and cross sheet references won't be copied over to your destination sheet only the values/ data will be copied over.
Melissa Yamada
Re: Jumpstart 2025 is filling up quickly — request an invite!
Looking forward to it!
Ray Lindstrom
Re: Adding a group in contacts column
Hi @User251
Unfortunately no, but I got round this by creating a master sheet that holds all my groups as a pre populated list of contacts in a cell. I then pull these group of contacts in a cell into any sheet I want using a simple index match formula.
It gives me additional flexibility as I can manage the groups of contacts across a single sheet, I can then use formulas based on criteria to pull different contact groups to that row and manage who receives notifications or access via dynamic view.
Just means when you update a group, you also need to update the respective group cell on the master sheet.
i.e. I use this with webform submissions that can allow me to send notifications to people based on the location submitting the webform or by category selected within the webform or both if you need.
Hope that helps
Thanks
Paul McGuinness
Paul McGuinness
How to Update Your Community Profile Email
Around here, our team sees all kinds of questions come in about Smartsheet, but one of the most frequently asked questions we get regarding Community itself is: How do I update my Community profile email?
This could be because:
- You got a new job or you’ve had a life change
- You’d like Community notifications to go to a different email
(remember that Community is tied directly to the Smartsheet account you use)
We’ve set up a process to make things easier on you!
- The earlier you follow this process, the better!
👉🏻 As soon as you think you may need to change your email, fill out the Update Community Profile Email form here using your current account. Try to give as much detail as possible. - Our team will privately message you if they have any clarifying questions.
For more information, check out the post in our Welcome Topic: Update your Community email address or password
We just revised this form thanks to your feedback and are always looking to improve, so keep the input coming. We are starting in English, but will translate the form and post into the multiple languages we serve in the near future.
We’re happy to keep you as an important part of this Community, no matter what change may bring!
Genevieve P.
Help Article updates - January 2025
Hello Community,
We’ve published the following new content:
To view the entire catalog of help articles, visit the Help and Learning Center.
Were the articles helpful?
Let us know by providing feedback at the end of each article.
Trelawney
Re: Can I start my project codes from zero for the 2025 year?
You would just replace each reference to UniqueID with the name of your Auto-number column. If there are spaces, numbers, and/or special characters in your auto-number column name, you will need to wrap it in [square brackets].
Paul Newcome
Re: How to find out if user has unsubscribed from notification
The best we can do is go into the automation properties and see how many people have unsubscribed, but there is no way to see who exactly.
Paul Newcome
Re: Handling Milestones when importing project plan data from Excel
That seems pretty frustrating!!! Have you thought of using automations?
- Set Up an Automation Rule:
- In Smartsheet, go to Automation > Create a Workflow.
- Set a trigger: "When rows are added or changed."
- Add a condition: If Start Date = End Date AND Duration = 1d.
- Action: Change Duration to 0d.
- This rule will automatically correct tasks that should be milestones.
Paul.Woodward