So I’ve got a ton of columns, I’m rolling up using ARRAYUNIQUE, I get ", " between each item getting rolled up. I tried adding ARRAYUNIQUE(values, “”) to the formula which doesn’t work, it does in a rollupfield for ARRAYJOIN, but not ARRAYUNIQUE. So ...
Ok so I got one that really threw me.
I have a lookup field on Tab 1, referencing Tab 3, I need that info in Tab 2, but rolled up, so I created a rollup field in Tab 2 that rolls up the lookup field in Tab1 (Tabs 2 & 3 aren’t linked). The contents lo...
I need some coding help. I have a duration field, I want it that way because its used throughout to add/subtract through my multiple tables, however the final step is exporting out through Zapier through an email. This produces the duration field whi...
I am keeping track of multiple hard drives and the amount of data in GB/TB on them, is it possible to for Airtable to have a formula to add computer data, aka GB/TB? So like if I had a drive that had 900GB and one that had 450GB they would add to 1.3...
So this formula works for me, the only catch is I need to extend it to seconds, not just HH:MM. How would I modify this formula to have accurate HH:MM:SS?
