Scott_Burton - profile

Scott_Burton · Mar 20, 2020

Scenario: One Table containing Multiple Projects (field called Project) and each Project has project activities (Activity). In my Table, I set up two fields: Project (name of the project) and the Project Activities (so each record will be defined as ...

Scott_Burton · Mar 13, 2020

Greeting and wow my second post in two consecutive days, yikes. First, my apologies if this has been answered, i am sure the logic was but applying it to my specific situation is my challenge. Objective: Create a Multiple Nested IF Statement for Proj...

Scott_Burton · Mar 12, 2020

Hello Everyone and forgive if this question has been answered in a previous Post. Quick background. I created a StartDate using the Date field. Then I created a second column to enter the number of days that the project is expected to be completed. T...

Scott_Burton · Aug 17, 2020

Hi Heather I am been working with AirTable for about a year now so not an expert by far. But I know how great it feels when someone can respond to your question so I hope this may be useful. So here is how I take a spreadsheet (like you I have the in...

Scott_Burton · Mar 24, 2020

When you create the Form, make sure you use the Share Form URL. Fill it out. If you did that correctly, then go back to your Base and look at the Grid view of your table. The results should be there.

Scott_Burton · Mar 13, 2020

The best thing of writing down your question is that during the process, it is amazing that you can actually figure out the answer to your question, which i did :slightly_smiling_face: Goal: Issue: Create a nested IF statement based on two differen...

Scott_Burton · Mar 13, 2020

After reading this regarding a two condition IF statement for Project Status where Project State is ‘In Progress’ and Difference between Start Date and Today’s Date is Negative, = Project in Progress. If difference between Start Date and Today’s Date...

Scott_Burton · Mar 13, 2020

Thank you for your prompt response :grinning:

User Statistics

User Activity

Summarize records (activities) based on each activity completed and a Group Field (Project 1, Project 2) and display as a Chart

Multiple Nested IF Statement - calculate Past Due based on if Start Date has yet to begin based on Todays date and if End Date is greater than today's date

Populate a Past Due Notice using EndDate and Computer's Clock

Re: Generating Forms as output (or exporting custom reports)?

Re: Where can I see the answer of the form I sent

Re: Multiple Nested IF Statement - calculate Past Due based on if Start Date has yet to begin based on Todays date and if End Date is greater than today's date

Re: Multiple Nested IF Statement - calculate Past Due based on if Start Date has yet to begin based on Todays date and if End Date is greater than today's date

Re: Populate a Past Due Notice using EndDate and Computer's Clock