I’ve built a formula that shows a Status in my Task field based on how many Sub-Tasks are complete:
IF({Sub-Tasks Complete} = 0, “ :radio_button: Not Yet Started”, IF({Sub-Tasks Complete} = {# of Sub-Tasks}, “ :white_check_mark: Complete”, “ :orange_...
I have a “Start Date” field and a “# Duration (days)” field and would like a formula that calculates the “Due Date” in work days.
I tried this formula from a YouTube tutorial:
IF(AND({Start Date},{Duration (days)}),WORKDAY({Start Date},{Duration (day...
So the first image, shows the fields I use to calculate the status. The second image is how I’d like it to appear to my client. When there is only 1 sub-task for a Task, it reads as “Not Yet Started”
