-
1
- #1
I got help from someone at work to help me get this working properly
Just wanted to share for anyone else who needs this.
I've searched on google how to do this but the only one I found used visual basic.
For security reasons our IT Specialist told me not to use that version (Macro Enabled)
Our IT Specialist after multiple tries was able to come up with this method.
I am using office 365 by the way.
First, go to File, Options, Formulas, then Enable iterative calculation
This will not work unless that box is checked
Make sure the Date column is formatted to display dates
Here is the template:
=IF(CellYouWantToCheck<>"",IF(CellWithDate<>"",CellWithDate,NOW()),"")
Just note that if you open this file on a different computer than the one you made the file on, you will need to make sure you enable iterative calculation for it to display correctly
Hope this helps someone else!
Just wanted to share for anyone else who needs this.
I've searched on google how to do this but the only one I found used visual basic.
For security reasons our IT Specialist told me not to use that version (Macro Enabled)
Our IT Specialist after multiple tries was able to come up with this method.
I am using office 365 by the way.
First, go to File, Options, Formulas, then Enable iterative calculation
This will not work unless that box is checked
Make sure the Date column is formatted to display dates
Here is the template:
=IF(CellYouWantToCheck<>"",IF(CellWithDate<>"",CellWithDate,NOW()),"")
Just note that if you open this file on a different computer than the one you made the file on, you will need to make sure you enable iterative calculation for it to display correctly
Hope this helps someone else!