Hey all,
I have a workbook in which I move records from one tab (table) to another regularly. The tables are identical, as I have to just move the records while the individual goes through a process, and track it. Each time I move the record to the new table, the field in which I calculate the age (based on birth date) brings in the previous table reference (subsequently screwing up all the records in the new table). I have to go in and edit it every single time. Is there a way to lock the formula so that it just references the DOB field each time, and not the previous table? Here's my formula:
=IF(ISBLANK([@DOB]),"",INT((TODAY()-[@DOB])/365))
Every time I move it, it adds the table reference before [@DOB].
Thanks so much! This will save me tons of time if we can fix.
Judi
I have a workbook in which I move records from one tab (table) to another regularly. The tables are identical, as I have to just move the records while the individual goes through a process, and track it. Each time I move the record to the new table, the field in which I calculate the age (based on birth date) brings in the previous table reference (subsequently screwing up all the records in the new table). I have to go in and edit it every single time. Is there a way to lock the formula so that it just references the DOB field each time, and not the previous table? Here's my formula:
=IF(ISBLANK([@DOB]),"",INT((TODAY()-[@DOB])/365))
Every time I move it, it adds the table reference before [@DOB].
Thanks so much! This will save me tons of time if we can fix.
Judi