Currently I work with a non-profit church team using a spreadsheet to schedule channels of communication for the year. They would like to move to another system like Airtable, but they like the fact they can visualize the empty channels on a spreadsh...
Here’s the situation. I’ve automated data coming in from a different platform that has a Single Select List. When the data comes in to Table 1, it’s an ID jargon that I need to have converted to a List Name in another Table 2 where ID to List Name is...
I have a date being pulled in from another system which is written in PST, it has GMT turned off. The date goes through some formatting formulas but is still written in PST. When I export a calendar (ical) with the finished formatted date, it seems o...
This is probably easy, but I’m using DATETIME_PARSE so that a field being called up can be converted to date, but sometimes those fields that are called up don’t have dates, so it returns an error where there is no date to convert, how do I make it r...
Thank you ahead. This is probably an easy one, but I could use the help since I’m not good at formulas or programming. Basically I am getting data from an API that is giving me IDs that need to be matched with Values. I got that happening but where t...
I understand, but I’m looking for a workaround. Another user pointed out maybe I can use automations. So when lookup field is updated, update single select field. Does that sound like it will work?
for now i’ve been able to solve this by doing this, but it’s not ideal for me because I need to do a formula to create Custom Field 1 before I can then use another formula to get rid of the error. looking to simplify somehow.
Formula 1 defines Custom...
Thanks for the help! I copied the formula but it’s not letting me save it saying it’s invalid? I also cannot change the field names because that’s the IDs and Values that the API is returning. I’m trying to get a project management app to one-way syn...
I was thinking it could be solved by doing if FIELD equals ID, return VALUE, else return blank. but when i put a ,BLANK() it still shows an error. Perhaps because the value is a date?
