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.

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

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

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!