Date Formulas
Hello Everyone,
I'm new to the smartsheet community, but have been using smartsheet at a basic level for a few years now, and I am looking for some help.
I have a form that collects information for me. Each time the form is completed and submitted it creates a new row in my sheet. In my sheet, I have a column called an "application date" and I want to know when the application closes by adding 60 days, which is kept in a "close date" column. I entered a formula in the first row of the "close date" column that calculates that date correctly and I then drag it down, and it updates each row correctly.
However, each time I save or leave the sheet, the formula disappears, which leaves the correct date in each row as a value, but when a new row is added, there is no formula to automatically calculate the "close date" of the new row. I have a other instances with similar date calculations and I am seeing the same result.
I feel like there must be a way to do this, but I cannot seem to get it to work. Can anyone tell me what I'm doing wrong?
Any help would be appreciated!
Cheers
Answers
-
Convert the column to a column formula. Right click on your cell with column and at the bottom it should say:
https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas
...
-
That's great, thank you. Seems to have worked on my test run. I'll keep an eye on it!
Thanks again!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!