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.
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...
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?
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},...
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.
