User Profile
ChelseaMD
Copper Contributor
Joined Jan 30, 2023
User Widgets
Recent Discussions
Re: Is there a formula/function for once true always true?
Thank you for replying. I get that it is confusing. This is just a much simpler example of what we have set up because I am looking for a solution to this specific problem. The actual data is a log of orders on one sheet. Then there is another sheet that is set up like an order form so when you enter the order number into the unlocked cell it populates all the given data onto a printable form. A third sheet does the same thing for a packing slip (ie. the shipping thing) Right now we just type "yes" in over "no" once the forms are printed. But that step keeps getting skipped and we have missing forms and/or duplicates of things all the time. And yes, I get that this is a lot of hassle but we are a small underfunded non-profit, and excel is what we can afford lol. We were looking for a way to make this happen so that it's harder to forget when we have printed order forms and packing slips. Therefore, the example shows the outlined box as the "order number" cell on the other sheet. that cell is constantly changing. And the only thing I am looking to do is mark "yes" and keep the yes once the number has ever been typed in the reference cell on the other sheet.Is there a formula/function for once true always true?
I need a way to type an order number into a specified cell and have the "shipped" column say "yes" once the numbers match. The column needs to say "no" until the order number has been entered into the specified cell. But once the number is entered and the values match, yielding a "yes" it needs to stay true, "yes", always. Also, this document is shared and updated frequently in teams so some functions are limited there. Is this possible? I have included screenshots of a simplified example of what I am working on. Ideally, E2 would remain "yes" even when G2 is updated. Thanks!
