How to get a computed column in spreadsheets

Hi guys,

Is there a way to bring a computed column to the google spreadsheet?

I specifically want this because glide has distance calculations. But need to bring this distance calculation specifically in the spreadsheet in my use case.

You can use an action that takes the value in the computed column and writes it to a basic column with Set Column Values.

1 Like

Yeah from an action its possible, but how about without an action :thinking:
Or to be specific, without a human action!

You don’t. The only way is with an action triggered by a user interaction. But, for a row of data to be altered, it would require a user doing something in the app anyway. Even a custom action to view the details of a list item could contain a Set Column action that would be enough to populate basic columns in the sheet.

The only alternative is to build similar logic with an arrayformula in the google sheet.

It might help to better understand your use case to see if this could be achieved easily.