Hello
I'm new to Smartsheet and need some help.
I'm tracking a project that for each participant, 12 different tasks need to happen to generate a complete data package. There's no set order for the tasks to occur, and there's no set time limit.
I want to use the 0/quarter/half/full symbols to track the status of each participant based on how many tasks have been completed, i.e. number of columns that are not blank.
I don't know if this should be an automated task, a function, conditional formatting, or something else. Any suggestions?
THank you