Woody Null Posted October 13, 2021 Share Posted October 13, 2021 I have a calculated column that is a long CASE/WHEN statement. The formula will be changing a lot, based on my user's feedback. Is there a way to print the formula into a text area so the user can see it I could copy/paste the formula into the text area, but then I would have to remember to copy/paste it every time I update the formula, which will be frequent. I would really like to have an automated way to do it. Link to comment Share on other sites More sharing options...
Woody Null Posted October 13, 2021 Author Share Posted October 13, 2021 Aha! I figured it out. I created a document propery that contains the formula. Now, I can insert the document property into the calculated column, and into the text area. Boom! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now