I know how to copy rows to another sheet when a criteria is met. But is there way to do only copy certain rows to the new sheet? I can do this via Zapier, but would love to be able to do it natively within Smartsheet.
just put criteria on the workflow, like other workflows that you can do. Its the plus sign between the initiator and the action.
Sorry L@123 I just realized that I wrote Row, but I really meant Column. Is there a way to only copy over certain columns of a row to the destination sheet?
Not efficiently. You can use the copy row workflow then hide the extraneous columns depending on compatibility with naming between the sheets and how big your sheet is that is receiving the information
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi need help in calculating date based on the cell value in "Grouping" If Cell value in grouping is "A" then add 45 days to the date in "End date" for the date required for populating next cycle count schedule. If Cell value in grouping is "B" then add 30 days to the date in "End date" for the date required for populating…
Just looking for a the formula to count the parent rows from the primary column. I dont need the children in this case.
Hi I have create a formula to calculate the % of margin but when i apply this to the column and there is current data, I get #DIVIDE BY ZERO. my formula is =[Margin $]@row / [Forecast Amount $]@row appreciate any help, thanks
©2024. All Rights Reserved Smartsheet Inc.