I’m trying to figure out if Glide can automatically convert project deadlines into actual dates. For example, I have three ongoing projects with deadlines set at 3 weeks, 4 weeks, and 4.5 weeks. As time progresses, I’d like my “Deadline” tab to automatically display the projects in order of their upcoming due dates, with the nearest deadline appearing at the top. I’m having some trouble setting this up in the Data Editor.
From when?
Project Start date?
Assuming yes, and you have that date in a column, you can calculate the other dates with a math column.
Date + 1 will add 1 day to a date. So to add 3 weeks, use Date + 21
1 Like