Can I use a workflow to add a Funtion into a column based on other columns data?
This idea is to pull text from one column to another; examplet Below
Primary Column: Country Names
Child Primary Column: Secondary Project
Workflow 1: When a new row is added, place formula to pull text from Child row into new column
Workflow 2: When new column is added, place formula to pull data from Parent row into new column (only needed when no child column is entered to not keep a Report with blank cells)
Report will show the column with the formula to fill the Country for specific projects.
Thanks to anyone that could help me with any option (not only workflows) I've tried formulas already, but IF is not working, no idea if I can use "" to pull a specific text string from a cell just like in Excel.
Answers
-
@Arturo U Unfortunately, you can automate formulas into a cell as it will case the formula in quotes to display the text.
Could you post some screenshots? You can use the =PARENT() formula for some things and we can help you with IF formula
-
Thanks Eric!
Here is the layout and the idea;
The "Parent" column on the far right needs to have a formula to display the content on the "Country" column, but I would appreciate if this would be based on the content of the "Country" colum, example, if it is "Feature" (or any other specific text) that it would display its own Parent Row (they will always be from a parent, hence the different formatting) and if its does not contain anything specific to just display the contect of that "Country" column row (for example in row 3, United States does not have any Child row, so on the "Parent Row" column just says "United States")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!