Projects

Master Projects

Name

Marketing

Music

Total Task Completion

NaN

NaN

NaN

NaN

NaN

Marketing Projects

Name

Master Project

Type

Status

Tasks

Task Completion

Done

Created By

Add Creator to Notify Completion

Marketing Project 1

Master Project 1

Website

Draft

In Progress

Social

Complete

Complete

Music Projects

Name

Master Project

Type

Label

Status

Tasks

Task Completion

Done

Created By

Add Creator to Notify Completion

Music Project 1

Master Project 1

Mix

Label 1

Draft

Label 2

In Progress

Album

Complete

Music Project 4

Master Project 4

Task 13

Tasks

Name

Marketing Project

Music Project

Status

Done

Due

Task 1

Music Project 1

Not Started

Jan 19, 2020

Task 2

Music Project 1

In Progress

Jan 20, 2020

Task 3

Music Project 1

Finished

Jan 21, 2020

Finished

In Progress

Finished

Finished

Finished

Finished

Finished

Done


or(not empty(prop("Add Creator when Done")), prop("Status") == "Complete")

or(

If either of the two following arguments return true, check the box.

not empty(prop("Add Creator when Done")),

Add Creator when Done is not empty.

prop("Status") == "Complete"

Status is Complete

Total Task Completion


if(not empty(prop("Marketing")), length(replaceAll(prop("Marketing"), "[^,]", "")) + 1, 0) + if(not empty(prop("Music")), length(replaceAll(prop("Music"), "[^,]", "")) + 1, 0)

By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!