Automated Workflow: Change Cell Value (of one cell) to value of another cell

aschneiderheinze1025

I have a column [H-Interest Code] that has a formula that generates an Interest Code (e.g., ESR: 5000 - High Quality Teams) that uses the [Academic Unit], a drop down column, [Program Code], and [Program Name] columns in the sheet. (The "H" in H-Interest Code refers to "hidden" since this column is hidden.)

Formula in [H-Interest Code]:

=LEFT([AU/Partner]@row, LEN([AU/Partner]@row)) + ": " + [Program Code]@row + " - " + [Program Name]@row

The [Program Name], in particular, may change during Stage 1 of the development process. However, once [Status] changes to "Stage 2", I want to change the cell value in [Interest Code] to capture the value in [H-Interest Code]. This way, even if [Program Name] is changed, and thus [H-Interest Code] will change, the value in [Interest Code] will NOT change.

I don't see how to set up an automated workflow that is triggered when [Status] changes to "Stage 2", and an action to change the cell value of [Interest Code] to [H-Interest Code].

Is there a way to change a cell value based on the value in another cell?

kowal

hi @aschneiderheinze1025,

I do not think it's possible to change the cell value from another cell value.

even if you pu the value =cellname@row etc. it wil give you something like '=cellname@row and it will not be linked.

Bridge would be here the only solution.

ker9

@aschneiderheinze1025

Could you use three columns to get what you need? One that has Interest Code formula, one that uses H-Interest code formula, and a 3rd column could pick which one to use based on stage?

aschneiderheinze1025

@ker9 Thanks for the suggestion. The "problem" I am trying to solve is how to make the Interest Code remain constant once [Status] is equal to "Stage 2". One of the values that makes up the Interest Code is [Program Name], and while in 85% of cases the [Program Name] doesn't change once [Status] is changed to "Stage 2". However, there are still those 15% of cases when last-minute decisions are made to tweak the [Program Name].

An automated workflow was a way to change the value of [Interest Code] and prevent it from changing even if [Program Name] changes.

[H-Interest Code] uses a formula to create the Interest Code, but it uses the current value in [Program Name]. I am not sure what would be in a third column, but if [Interest Code] is set to [H-Interest Code] or "picks" between two columns, it still uses whatever the current value of [Program Name] is, which means it will change anytime [Program Name] changes.

Andrée Starå

https://community.smartsheet.com/discussion/137475/automated-workflow-change-cell-value-of-one-cell-to-value-of-another-cell

Hi,

I hope you're well and safe!

Please look at my post below, which contains a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!