I have the first column with a start date (Date Submitted). I am wanting to know how to code so that the next column will show how many days are passing since the start date (Date submitted). Then if the status (another column) comes back as closed it’ll then show closed.
Date - Date submitted to show days passing
+18Hi @Clair_Arthur :wave: . Welcome to Airtable Community!! :smiling_face_with_three_hearts:
The formula code that I would use is [IF(Status="Closed","Closed",DATETIME_DIFF({Date Submitted},TODAY(),'days')*(-1))]
hth,
Nathalie@VAcePro.com
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.