Is there a wide to hide data in certain cells using a formula?
I am trying to work with date data coming from Memberstack that appears in UNIX form.
I have a column converting the UNIX data to readable data.
DATEADD('1/1/1970',{UNIX Renewal Date from...
Ok. So DATE_FORMAT works and get’s me to organize, but it also throws in a whole bunch of errors. I’ve been playing around with IF statements based on some other threads, but I can’t seem to get it to showcase in a way that doesn’t either break the c...
KVachon:
IF(AND({UNIX Renewal Date}='',{Manual Renewal Date} = ''),'',Insert your existing formula here)
Hi KVachon - Thanks so much for the help! It pulled out all the cells with incorrect data leaving only the renewal dates with actual data....