Frequently asked questions
Can Smartsheet copy conditional formatting between sheets?
Not directly. Conditional formatting carries over when you use Save as New on the same sheet, but there is no way to copy rules from one unrelated sheet to another. Grid Tools adds that capability.
Does Grid Tools copy the rule order as well as the rules themselves?
Yes. Rule order in Smartsheet's conditional formatting affects which rule wins when multiple conditions match the same row. Grid Tools preserves the source order in the pasted result.
Can I paste conditional formats into a sheet that already has existing rules?
Yes. Grid Tools appends the pasted rules to the target sheet's existing rule set. You can reorder or delete rules afterward using Smartsheet's standard conditional formatting editor.
Do the column references in the rules transfer correctly?
Rules that reference columns by name will apply to the matching column names in the target sheet. If a referenced column does not exist in the target, that rule will need manual adjustment.