This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi. I’ve set up a few automations with no problems, but I am not sure how to do this one… or if it can be done.
I have an AutoDate column, so when a form entry comes in, it auto-dates the entry of the form. However, I need to then copy that date over...
Help! I keep pasting this formula into Airtable, and it deletes it after the 5 Item section. Even if I can get it to “take” the 7 and 10 item part of the formula, it says there’s an error. Where is the error?
IF(AND({Number of Items}=5, {VA Recipient...
This is our current working formula.
IF(AND({Number of Items}=5, {VA Recipient?}),57.39, IF({Number of Items}=5, 55, IF(AND({Number of Items}=7, {VA Recipient?}),73.18, IF({Number of Items}=7, 70, IF(AND({Number of Items}=10, {VA Recipient?}),88.98, ...
I have this formula. If there is no date, the formula errors out. I need it to be the exact same formula but if the date field is blank, it still fills in all the other columns.
Here’s the formula: DATETIME_FORMAT({Date}, ‘YYYY-MM-DD’)&" “&Type&” || ...
Thank you so much. It is still not working for some reason. Any other thoughts? Also, thank you SO much for your help. Really appreciate it.
SWITCH(
IF(IS_BEFORE({Date}, “2021-10-01”), 1, IF({Date}, 2)),
1, SWITCH(
{Number of Items},
5, 45,
7, 60,
10...
If you happen to be able to help me again, I’m trying to get this one…
Right now, another formula is:
IF({Number of Items}=5,45,IF({Number of Items}=7,60,IF({Number of Items}=10, 75)))
I want to add that this is correct before 10/01/2021, but after t...
Thank you. Yes, I am trying to sort out HOW to set up the automation. I get stuck on the last step. How do I tell it to copy the date from another field?
In the screenshot, I’ve inserted the AutoDate field under the Date field, but it won’t let me te...
