• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional recalculation?


Hey Chandoo,

I have a curly one for you.

We've created a sales order form template that we sent to our suppliers to complete and send back.
We have a today() formula to refresh the form while the customer fills it in together with the details of the order.

The customer then emails the template back to us but if we open it the next day or after a week, the date will refresh.
Is there a way we can lock it the date the customer fills in the form without using macros? We don't want to use macros because some customers don't like using them and the customer is always right!

I was think maybe of linking the date to the user or maybe a cell with a Yes/No confirmation that the order is final but what if the customer reuses the form for a new order.

Any thoughts?

Peter Bartholomew

Well-Known Member
Options might include introducing your customers to Ctrl+; to insert a date or allowing a single step of iterative calculation. Once you mark the form as received the date formula could take the date from itself rather than the TODAY() function.