How do I apply a formula to an entire column?
I have a data sheet with a column labeled "DUE DATE". When someone submits a form I want the due date to automatically update to be two days from date of submission. I have it auto populating to current date, and know the formula to get it to add two days, but can't figure out how to apply the formula to the column so that it auto populates adding the two additional days.
Best Answer
-
Hi Taylor,
It sounds like the existing column should be "submitted date" and you could need another column for "due date." Once created, add the formula and right-click on a cell that contains a formula, and select "convert to column formula."
Answers
-
Hi Taylor,
It sounds like the existing column should be "submitted date" and you could need another column for "due date." Once created, add the formula and right-click on a cell that contains a formula, and select "convert to column formula."
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!