NeroXHelper I3 years agoSolvedReplace values to formula Hello, How can i use formula to "Replace values" ? I have column with dates and i want replace values "null" to formula "=TODAY()" What can i do? Thank you. Show MoreBA_Pete3 years agoHi NeroX , First, replace null with a date value: Then, in the formula bar, change the auto-generated code from this: ...to this: Pete
BA_Pete3 years agoHi NeroX , First, replace null with a date value: Then, in the formula bar, change the auto-generated code from this: ...to this: Pete
BA_Pete3 years agoHi NeroX , First, replace null with a date value: Then, in the formula bar, change the auto-generated code from this: ...to this: Pete
BA_PeteSuper User3 years agoHi NeroX , First, replace null with a date value: Then, in the formula bar, change the auto-generated code from this: ...to this: Pete
EinomiHelper V to BA_Pete3 years agoSorry BA_Pete our messages crossed each other Your solution is better 🙂 glad to see it 🙂NeroXHelper I to BA_Pete3 years agoThank you both. It is solved. 🙂
EinomiHelper V to BA_Pete3 years agoSorry BA_Pete our messages crossed each other Your solution is better 🙂 glad to see it 🙂
Related contentReplacing values with IterationsIf formulaReplace Errors values with Null valuesReplace valueshow to dynamically replace values for multiple columns
