Auto populate a sheet based on criteria
Hello, I have a sheet that lists of all company projects with Project Names and many columns of associated date. I would like to have a sheet that automatically populates all of the project names based on a criteria. For example project not run in the U.S. One I have the project names in the the new sheet, I can use Data Mesh add in the other columns, but I am stuck on how to bring in all of the project names. I would like to this to happen automatically when a new project is added to the sheet. I cannot use a report because I need to add additional columns. (It would be great to have the ability to have the query function of a report on a sheet!)
Best Answer
-
You can use a report as the source in a datamesh workflow to bring on new projects with a unique id (can only add new lines hourly). Then you can have a second datamesh workflow that only updates data from the source sheet to the target sheet (this one could keep your data updated immediately).
Answers
-
You can use a report as the source in a datamesh workflow to bring on new projects with a unique id (can only add new lines hourly). Then you can have a second datamesh workflow that only updates data from the source sheet to the target sheet (this one could keep your data updated immediately).
-
Thank you Samuel. I had considered this and may as the number of projects grows. I have opted for a manual cut and paste for now. I could also use a hidden helper column as the reference row also.
-
yeah where you have an if statement for your criteria, if it matches the criteria, populate unique ID, otherwise blank, then only the ones where unique ID populates will move over.
I use the report option a lot though, it's easier to set up and adjust if needed, and you don't need helper columns.
-
What I would really like to see (but may be technically hard) it the ability to have "report" or "query columns" with in a sheet, where you would have the full usability of each. I often want to pull specific data such as project data, for specific projects based on criteria, then add additional columns to it that will be used for a select purpose.
-
You could maybe leverage dataTable for that.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!