Forum



00:51

11/12/2012

To begin with… love the product!
Tougher question. I need to add dates from a previous row and field. Example:
# | Start Date | Number Mos | Event |
1 | 1/2012 | 3 | Payment |
2 | 4/2012 | 6 | Vacant |
3 | 10/2012 | 1 | Sold Item |
I want row 2 to update the start date by adding 3 months to 1/2012 result of 4/2012 and then row 3 to update 6 months from 4/2012 etc etc. A continuation from the previous date/data.
Or maybe an easier way to ask the question, can you put formulas in the update or cell value kind of like excel.
B3=B2+C2 and B4=B3+C3 etc etc.
I saw in other posts that it does not do any calculations... I can do the formulas for the data but how can I populate the update field or insert field with the data?
Any help or advice would be greatly appreciated.
Most Users Ever Online: 715
Currently Online:
38 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66