Hi everyone, i'm a new user of airtable and just wanted to ask if there's a way to do this?
- The first Col row 1 (red box). If that specific row is not blank.
- It will fill out the entire next col (blue box).
Formula based on row
+3
+20Hi Fred welcome to the forums!
Simple answer, no.
Long answer, no, but getting a better understanding of how Airtbale works may give you a better solution than what you're trying to achieve.
Since Airtable is a database and not necessarily a spreadsheet, the formula you're trying to make wouldn't work. Information stored on each record is not able to change dynamically from view to view. However, implementing "Link" fields, "Look Up" fields, "Roll Up" fields, and "Formula" fields will come in very handy when we have data interacting with each other.
Hopefully, you do a bit of playing around to see if Airtable works for you. It's very exciting when you're able to implement and build your own systems and infrastructure.
I'd suggest having a look at the bases others have built over on the Airtable Universe for inspiration haha
https://www.airtable.com/universe
Justin NgProgramme Coordinator at Sistema Aotearoahttps://www.sistemaaotearoa.org.nz/
+3Hi Fred welcome to the forums!
Simple answer, no.
Long answer, no, but getting a better understanding of how Airtbale works may give you a better solution than what you're trying to achieve.
Since Airtable is a database and not necessarily a spreadsheet, the formula you're trying to make wouldn't work. Information stored on each record is not able to change dynamically from view to view. However, implementing "Link" fields, "Look Up" fields, "Roll Up" fields, and "Formula" fields will come in very handy when we have data interacting with each other.
Hopefully, you do a bit of playing around to see if Airtable works for you. It's very exciting when you're able to implement and build your own systems and infrastructure.
I'd suggest having a look at the bases others have built over on the Airtable Universe for inspiration haha
https://www.airtable.com/universe
Thank you for taking time answering my concern! Will do some exploration more on airtable. Thank you again.
+35@Fred00 Since you are new to Airtable, you might enjoy my free Airtable training course, which you can take for free by signing up for a trial membership with LinkedIn Learning: https://www.linkedin.com/learning/learning-airtable/
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.