Can anyone explain to me how to avoid this issue when doing sheet to sheet copy automations? I will provide a screenshot below. It seems that I will put something on sheet 1 and when I refresh sheet 2, it is further down.
I hope you're well and safe!
Try deleting all the empty rows above the copied rows.
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
@Andrée Starå ,
Will I have to keep doing this? for every sheet or every time this occurs? Is there a way to avoid this?
No, if you remove the empty rows, it shouldn't be an issue going forward.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Hi all, I've set up a Accident and near-miss report through a form, I want the entries to be view-able by staff (not all columns, as they might). So I have made a report -filtering on what I do and do not wnat to display- which I have in turn -among other metrics etc- put into a safety-portal dashboard. The issue I am…
I am a business user but Data Shuttle is not activated. How to activate it?
Hello I am trying to calculate a sheet summary field to show how many times a value appears in the Location column. I am using the Count if function but it is only returning a value when the "location" is presented on it's own. For eg: my formula is =COUNTIF([*Location]:[*Location], "VIC"). This formula responds with a…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.