1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Make a cell Mirror another when not Blank, Editable otherwise

Using Google Sheets

I want cell C1 to be editable via free text, but if cell A1 is filled, I want cell C1 to instead display what cell A1 has.

Basically I want something akin to the functionality of

=If(isblank(A1), [Allow this cell to be editable], A1)

But where actually editting the cell doesn't make me have to reinput the formula again

I've been trying with conditional formatting and Data Validation tools, but I can't seem to both make C1 editable and mirror A1 conditionally without one breaking the other

The other option I can think of is having another column and parsing it that way. So doing something like

=If(isblank(A1), B1, A1)

And locking C1 out of being editable, but that uses a lot more space in the sheet.

Thanks

submitted by /u/pastamancer8081
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#google sheets
#Excel alternatives for data analysis
#data visualization tools
#data analysis tools
#rows.com
#AI formula generation techniques
#big data management in spreadsheets
#self-service analytics tools
#generative AI for data analysis
#conversational data analysis
#Excel compatibility
#business intelligence tools
#collaborative spreadsheet tools
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#formula generator
#enterprise data management
#big data performance
#Excel alternatives