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'm trying to write a formula that creates links for all the records of a particular table. CONCATENATE("https://airtable.com/apppHrkLvUlS6WHMn/tbluWhdAjZM8xU9DD/viwCnMkKvccWgTatL", RECORD_ID()) This is creating a broken link. Am I missing somethi...
Hi everyone,I'm having trouble with this formula. Can you tell me what I'm missing?It comes up blank.Thank you!SWITCH({Recurring Frequency},"daily", DATEADD({Date to work on it}, 1,'days'),"weekly", DATEADD({Date to work on it}, 1,'weeks'),"monthly",...
I have a "date paid" date field that I've realized I could automate better by transitioning it to a checkmark (paid?) and a last modified date field. But when I do that I lose all the paid dates paid (which impacts other calculations throughout my ta...
How do I revise this formula so that it gives me both the week # and the range of days in that week?
DATETIME_FORMAT({Date to work on it},‘ww’)
Also, is there a week to do a week number that doesn’t start over at the beginning of the year?
All I real...
I have dates on two tables and I want to get the sum of a different number on each table. I have a task table with a date on it and a field that has the duration of the time expected to complete the task in interger format. I have another table that ...
Thanks Adam,
There is one record between 4-4:59. The odd part is that it starts at 10am. 6am is there but it’s not until after 4pm. I wonder if it has something to do with GMT?
Tobin
