Jocelyn_Piazza - profile

Jocelyn_Piazza · Sep 09, 2020

Hi I had a view in one of my sheets and the view just went missing. I don’t know where it went. Do you know how to retrieve a lost view? not a lost base but a view within that table.

Jocelyn_Piazza · Aug 07, 2019

If the cell is BLANK I want it to show up as blank in the field rather than ERROR For example: IF ({Date of Donation} = BLANK()," “) but this isn’t working and right now I do not have the if statement so it is showing up as error. I also want another...

Jocelyn_Piazza · Aug 13, 2019

wow thank you so much for all your help

Jocelyn_Piazza · Aug 13, 2019

Great! This works, thanks so much. But I have one more question. If the cell doesn’t have an org name or a date nothing is showing up, I would like for at least their first and last name to show up?

Jocelyn_Piazza · Aug 13, 2019

Just to verify this is the full code that should work? DATETIME_FORMAT({Date of Donation}, ‘MM/DD/YY’) & " | " & {First Name} & " " & {Last Name} IF( {Date of Donation}, DATETIME_FORMAT({Date of Donation}, ‘MM/DD/YY’) & " | " & IF( AND({First Name},...

Jocelyn_Piazza · Aug 13, 2019

Yeah that’s exactly what I want it to do. Except sometimes there is no date. maybe that’s why it doesn’t work? It just says error invalid and it won’t let me enter it. Thats exactly what I have my fields as too.

Jocelyn_Piazza · Aug 09, 2019

I am also in the far left column coding this I don’t know if it makes a difference

User Statistics

User Activity

A view went missing

IF statement, when there is a blank cell

Re: IF statement, when there is a blank cell

Re: IF statement, when there is a blank cell

Re: IF statement, when there is a blank cell

Re: IF statement, when there is a blank cell

Re: IF statement, when there is a blank cell