Update Formula to Include When New Columns Are Added
I have a sheet that tracks the number of hours by the team on each project. When a new project is created an additional column needs to be created (if anyone knows of a way to have it automatically added when a new project is created from a template that would be amazing) and named with the new project name. Then the Team column needs to have the formula updated to ensure that it's reviewing the new column for information. Is there a way to have the new row automatically entered in the formula? The formula I have is to show the team name if there is anything in row under the project name. =IF(OR(Apollo@row <> "", Onboarding@row <> "", [Test June]@row <> "", Test@row <> "", Template@row <> ""), Teams@row, "") is the formula I use now but wasn't sure if there was one that I could create to just review if anything is in any of the columns to the right of the formula.
Best Answer
-
Is there a reason you are having new columns added instead of new rows?
Answers
-
Is there a reason you are having new columns added instead of new rows?
-
Hmm I hadn't thought of that. Let me flip the data and see if that works better.
-
That worked great! Much easier than having others update the formula each time. Thank you!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!