I am writing a column formula and get invalid operation error

Jerry Corpening

I am using this formula to calculate % of task time but get invalid operation error. Task time is the amount of time spent doing a particular task divided by the shift hours (9)

=[Total Task Time]@row / 9

Matt Johnson

Hi @Jerry Corpening

Maybe check the column types. I tested it and it worked ok on my end. If you use 4hr or 30min, then you'll get that error. It needs to be straight numbers for that formula to work. You could probably find a formula that searches for that text and removes it if needed.

I hope that helps.

Matt

Jerry Corpening

Thanks Matt!

Andrée Starå

Hi @Jerry Corpening

I hope you're well and safe!

Strange!

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing)

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Matt Johnson

Hi @Jerry Corpening

Maybe check the column types. I tested it and it worked ok on my end. If you use 4hr or 30min, then you'll get that error. It needs to be straight numbers for that formula to work. You could probably find a formula that searches for that text and removes it if needed.

I hope that helps.

Matt

Jerry Corpening

Thanks Matt!