I am writing a column formula and get invalid operation error
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
Best Answers

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

Thanks Matt!
Answers

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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:andree@workbold.com  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

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

Thanks Matt!
Help Article Resources
Categories
Check out the Formula Handbook template!