The facepalm I made as I read that. I didn't even think about the hyphen in E-Comm and now I'm kicking myself three times. Once for not thinking of it, and again for insisting we stay consistent and renaming EComm to E-Comm EVERYWHERE. Ugh, hindsight. And for anyone wondering... the third time is du...

I have a custom field called E-Comm Request Type with the field choices of NPI, Promo, GCX Campaign, SKU Refresh, and New Retail Setup. I'm trying to do a calc field that will combine these options into two categories Revitalized or New. I've quadruple-checked my calculation below and cannot figure ...

This is a fantastic idea! We might have to hop on a call and talk this out as I explore a little deeper.

Same as Sara and JM, would love to participate but the link isn't valid.

THANK YOU SO MUCH RICHARD!!!!I don't know if I ever would have thought about using -56. Works like a charm!

This is helping me think of more things to consider My top priorities are:Getting a 2020 baseline to start exploring how to tell the story that Creative Ops is achieving high-level goals within Workfront (better data clean-up, more efficient support, training users)Developing streamlined reports tha...

I'm not sure why but whenever I try to do a calculated column my brain goes foggy. I want to simply add a column to my report that calculates 8 weeks before a custom date field called "E-Comm Due Date". Can someone please put me out of my misery and give me the value expression??

Gotcha. Thanks for the explaination

Doug you've at least confirmed that this isn't something easy that I was overlooking. Thank you for that!! My overall goal is to be able to provide Project Managers two columns on their weekly status check reports. The purpose of these columns are to see if hours had been logged to the project and a...

Is it possible to add a column to a Project Report that calculates how many hours were added to the project within the last week? I feel like the text mode is probably something really simple that I've overlooked.