I am trying to pull a column data from a different sheet using CELL LINKING option. However, when there is a data change, CELL LINKING doesn't bring the new data. Note : I am using Data Uploader to retrieve the data with REPLACE option
Hi @Tamizamuthan Vedachalam,
It could be that the Replace option in your Data Uploader workflow may be causing the issue with your cell links. Per the Data Uploader Help article under the section titled Select a Target Sheet and Upload Action, it states: IMPORTANT: Choosing replace will delete all context added including cell links.
Just to be sure though, I highly recommend reaching out to the Smartsheet Support team with this issue as they will be able to review your workflow configuration more in-depth to confirm the root cause and offer steps for troubleshooting. You can create a Support ticket here: https://help.smartsheet.com/contact/smartsheetapp
Thanks for reaching out. I am using the similar option which you are suggesting to perform cell linking. I agree now the challenge is, when my source data is entirely deleted and replaced. Target sheet is NOT getting replaced automatically and I need to manually refresh or re-establish cell linking. Is is something a limitation of product itself ? OR we have any other alternative solution for this. May be I will raise a support ticket in that case
We have a spreadsheet with data that needs to be updated/validated twice a year. We wanted to use a workflow, but some owners/approvers of the data have 150 rows to their name. We don't want to flood their email with that many emails or have to go through 150 lines that way. We are working with the idea of sending an…
Hello- I am trying to remove the item names from the right side of the gaant chart. Is there a way to get rid of those and preferably add other column information instead? I see the settings pop up but there is no option to get rid of those labels. Thank you!
We would like to request the ability to add multiple conditions to a Conditional Formatting rule. For example: If Step="Backlog" and Flag=Yes, mark row orange.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.