Daniella_Delato - profile

Daniella_Delato · May 30, 2018

Hi There! I have a table that tracks all my “Projected Opening Dates” for each project (each project is a record.) The other table has all the tasks needed to be completed for an individual project. I would like to link the “Project Opening Date” fro...

Daniella_Delato · May 07, 2018

Hey Airtable, I need your help!!! I am a Project Manager and we plan for our projects based on the date we start construction. All tasks that need to be completed are categorized by when we need to complete them, for example, the oven needs to be ord...

Daniella_Delato · Jun 14, 2018

any chance the @Airtable_Team will look at this??? I NEED This!!! Please!

Daniella_Delato · May 30, 2018

You got it right, I don’t want to do that though, it would make things much more confusing for me :frowning:

Daniella_Delato · May 29, 2018

Jeremy_Oglesby: IF( {Status} = “Done”, “Completed”, You’re amazing, thank you so much for your help! I’m able to learn a lot through you guys, thank you for your time!

Daniella_Delato · May 29, 2018

This worked, Thank you so much!!! Could it make it a lot more complicated to add another IF statement that if the Status says “done” then “When is it due” would say Completed instead of Past due?

Daniella_Delato · May 27, 2018

IF(Due="",“Not Set”,IF(AND(DATETIME_DIFF(Due,TODAY(),‘hours’)>=12,DATETIME_DIFF(Due,TODAY(),‘hours’)<=48),“Due Soon”,IF(IS_BEFORE(Due,TODAY()),“Past Due”,IF(IS_SAME({Due},TODAY()),“Due Today”,“Upcoming”)

User Statistics

User Activity

Linking Data between tables

Relative Due Dates

Re: Link to other base

Re: Linking Data between tables

Re: Formula for "Due" and "Past Due"

Re: Formula for "Due" and "Past Due"

Re: Formula for "Due" and "Past Due"