Hi everyone,
wanted to ask one thing that how we can move one column value to a new column in a specific row using a formula.
As you can see this screenshot.
I have three column and I want to move the 'vid-offset' - json_value to a new column. (marked yellow)
I' using this formula but it's not working for me:
if [has_more]="true" then ([JSON_Name] = "vid-offset" AND [JSON_ValueString])
else Null()
endif
Please help me how I can do it.
Thank you
Solved! Go to Solution.
Use Multi Row Formula
if [has_more] = "True" and [Row+1:JSON_Name] = "vid-offset" then [Row+1:JSON_valueString] else null() endif
Yes @dhrathod I did the same thing using Multi-Row formula. Thank you