How to track burn rate
I am trying to write a formula for burn rate in smartsheet. (Summary11 - Summary14) / (TODAY() - [Delivery Date]19). I want this formula to extend to [Delivery Date]514 as the data is being entered each day. When I use [Delivery Date]514 in the formula I get # DIVIDED BY ZERO error message. When I include the IFERROR in the formula I get #UNPARSEABLE error message. What I am trying to do is track the spend from the purchase order amount for each day a delivery is received. ( =purchase order amount – material cost/ (2nd Delivery Date) – (1st Delivery Date) for the complete month…….Can this be done in Smartsheet?
Answers
-
Are you able to provide some screenshots for reference?
-
Each time a delivery is made the cost of delivery is subtracted from the balance of the purchase order. The formula captures the burn rate for the first delivery date ([Delivery Date]19). This is the first date entered into row 19. I want the formula to continue calculating for time delivery is made. For example The next date is May 17, 2002. The delivery cost is $1886.25. This amount is subtracting from the purchase order balance but the deliver date is not being calculated. I can change "Today()") to the next delivery date (May 17, 2022) and the formula works. But I want it to automatically work each time the delivery date and corresponding delivery cost is entered.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 361 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!