This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi ! Coleagues, I have a project in AirTable in a single table with 174 rows and 11 (eleven) categories that I can group these rows. Each of these 174 tasks has its own "Start Date" and "End Date" column, with date format in it. I want to...
Hi ! I created a column to identify if the "End Date" of a task belongs to one of the weeks below, based on the ISO numbers for each week of the year (1~52 or 53). But I am facing an error due to the year, that I cannot overpass. It is ...
Hi! We have a huge project with several tasks where I need to add to a timeline the completeness average percentage and, I think, this can be done in single task with this summary of the average percent of the grouped tasks. In other words: ...
Hi! In my project plan I need to use hierarchical (or outline) numbering such:1 ~ 1.1 ~ 1.2 ~ 1.2.1 ~ 1.3 ~ 1.4 ~ 1.4.1 ~ etc. (print 1) I've be doing this manually, but it would be great to have it being created automatically. I got the...
Hi!I did a slight change to match my board:IF( {Percent} & "", IF( {Percent} < 0.25, "",IF( {Percent} < 0.5, "", "" ) ) &" " & ROUND({Percent} * 100, 0) & "%" )And now I need to make this result be used as the color of the task (register).But the ...
Hi! Thank you for the response @TheTimeSavingCo . I will check your proposal as soon as possible and, since done, I'll let you know the result here.Best regards!@NLOIA Someone who learns.
Hi! @Ben_Young1 , I did the same formula in the field "Start Date" in my table, but the resulting cells returns only blank. Any hint why? My intention is to obtain the earliest "Start Date" and the latest "End Date" from some registers group...
Hi ! Many thanks @TheTimeSavingCo !! Your formula did the job! I will accept it as the solution. This allows better view of the tasks under the actual sprint and also the effort involved. I made just minor adjustments for a better de...