Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 06, 2019 02:49 PM
Hi everyone!
I’m trying to make a formula where I can only see the date of the project is about to expire. I don’t know if that’s something it can be done, but it would really help me because I don’t want to be seen always all the dates, but only the ones I’m about to work.
I hope someone can help me.
Thank you in advance!
Sep 06, 2019 03:44 PM
Hi Luciana,
I found this great resource that might help you out regarding your question:
The top 10 time-saving Airtable date formulas
I hope this helps.
Sep 07, 2019 02:44 AM
Hi @Luciana_Boasso - if I understand correctly, I think you only want to see the projects/tasks that are due soon, not all tasks - is that right? If so, this is best achieved using views on your projects table.
If I have a (simplified) projects table like this:
I can create a view “Due Soon” and filter out tasks that are due after an amount of time into the future:
If you drag your Due Soon view to the top of your list of views this will then be the default view for you:
JB
Sep 09, 2019 06:26 AM
Yes, actually I have thought in doing something like that, but maybe it was a way to make a filter with a formula where I don’t have to go to another view.
Thank you for your time, I’ll try it anyway :slightly_smiling_face:
Sep 09, 2019 06:32 AM
I saw that top 10 but the thing is I don’t understand why is comparing to dues from different fields.
I want the formula compares dues from the same field. Is that make sense?
Thanks for your time! :slightly_smiling_face: