Why don't I see formula based columns in the column list in Zapier when I am creating/updating a row?
Since formulas apply to the entire column, we do not allow you to edit them on a per-row basis. For this reason, we do not expose them in the create/update row action in Zapier.
How do I write to people or look up columns?
If you write to a people column or a look up column, we will auto-convert raw text values based on an exact match (eg "Molly" won't map to "Molly Rose" or "Launch Site" won't map to "Launch the Website")
Do you support time stamps in your date-time and date column formats?