We have a project board with 163 columns, and automation in place to duplicate the item if the project status changes to Fail. We would like some columns in the duplicate to clear when it is created. I know how to “clear column” from the existing board, how is this done for the duplicate board? TY
1 Like
Hi @rfrancies - if you utilized a separate column as an identifier to know when a new item is created/duplicated through this process you can better manage the clearing of columns.
For example, create a Status column called “Duplicate” with an option of Yes and a default option of No. Then use the following:
- When Status Changes to Fail, set Duplicate to Yes and Duplicate the item
- When item created and only if Duplicate is Yes then clear column A, and then clear column B, etc…
Hope this helps!
Mark