Heather_Parker - profile

Heather_Parker · Jun 28, 2021

Hi everyone - I want to create a formula that will return a date value only if the value in a separate field {campaign duration (days)} is greater than 10. I also want the field to stay “clean” even if the bounding dates (Live and End) aren’t filled ...

Heather_Parker · Jun 23, 2021

Hi everyone - I’m still very new to Airtable and ran into a formula error that I’m trying to solve. Ideally, we would like to group tasks by the week they are due. I was able to find the formula to output the week number but can’t seem to find one th...

Heather_Parker · Jun 29, 2021

Hi Kamille - {Campaign Live Date} is a Date {Campaign Duration (Days)} is a calculated field that is formatted as an Integer. The formula calculates the length of the campaign in days/2 so that I can easily see the campaign mid point - formula as fol...

Heather_Parker · Jun 23, 2021

Thanks @Kamille_Parks! Worked like a dream.

User Statistics

User Activity

Issue with Nested If Formula - Value Returned Isn't a Date

"Week of" vs Week Number - Issue with Formula

Re: Issue with Nested If Formula - Value Returned Isn't a Date

Re: "Week of" vs Week Number - Issue with Formula