Is there a Column Formula I can use to always assign tasks to myself?

Callie Langford

I'm trying to sync up my personal task list along with client task lists to all flow into one report, which means I need to assign everything in my personal task list to me in an Owner column. Is there a way I can automate that with a Column Formula?

Bassam Khalil

Hi @Callie Langford 

Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Andrée Starå

Hi @Callie Langford

I hope you're well and safe!

Try something like this. (change to your email address)

=IF([Task Name]@row <> ""; "andree@workbold.com"; "")

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) 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!

Callie Langford

Screenshot attached. @Andrée Starå - the formula came up as unparseable unfortunately, though I may not have it totally correct.

Andrée Starå

@Callie Langford

Try this one.

=IF(Item@row <> ""; "andree@workbold.com"; "")

or this one.

=IF(Item@row <> "", "andree@workbold.com", "")

Did one of the work? Where are you located?

Callie Langford

@Andrée Starå - the final option works as a formula but it only inputs my email and doesn't count it as assigned to me.

Andrée Starå

@Callie Langford

Try saving the sheet and see if works.

Did it?

If not, paste the formula here.