


2 years ago we had $X rate for billing per role. Last year it went up by $x. This year it will go down by $x. I don't want to lose the historical billing rate information, so I'm trying to figure out to write an if statement on a custom form - something like if (year=2019, billing rate = $x), if (year = 2020, billing rate = $x, if(year = 2021, billing rate = $x), etc. Of course that isn't the right syntax - I'm just trying to figure out the logic. How would I capture this in an if statement for a calculated field in a custom form? I'm stumped. I need your expertise please! 😊
Topics help categorize Community content and increase your ability to discover relevant content.
I have the EXACT same problem. I did just go ahead and adjust the billing rate up, losing the accurate data for the older jobs. That really, really made me frustrated. Please lmk if you get a good answer here!
Views
Replies
Sign in to like this content
Total Likes
Hi Jenny,
I suggest you create Billing Records to mark as Billed and (more importantly), “lock in” those historic rates, either manually, or using our Auto-Bill solution.
Regards,
Doug
Views
Replies
Sign in to like this content
Total Likes
Hi Doug. Thank you. We would like to do this natively within Workfront, without adding an application.
How do you create a billing record?
Views
Replies
Sign in to like this content
Total Likes
Views
Replies
Sign in to like this content
Total Likes