Unique value in each row under Primary Column?

Bradley Berneche

Is it required that each cell in the Primary Column contain a unique value, or is it permissible that the value be repeated within a given sheet?

Andrée Starå

Hi Bradley,

No, fortunately it doesn't need to be unique.

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Bradley Berneche

Thank you Andrée. That answers my question.

Andrée Starå

Hi Bradley,

No, fortunately it doesn't need to be unique.

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Bradley Berneche

Thank you Andrée. That answers my question.

Andrée Starå

Excellent!

Happy to help!

Mathias Lee

This was helpful but what is we want the Primary Column to be unique? Example: We are trying to use the primary column to assign unique numbering of issues.

Is that possible in the Primary Column or should that be done in another column?

Thanks,

Mathias

Bradley Berneche

That was kind of the way I was thinking when I asked the question, but in the end, I simply inserted another column that auto-generates a "Job" or control number which we use as a unique identifier for each project.

Andrée Starå

@Mathias Lee

Hi Matthias,

You could use the JOIN feature together with a unique row id or similar. (Similar to @Bradley Berneche's advice)

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!