I’m having an issue catching an error return in my formula field. The field is called Status and in it, I check if a task is complete (i.e., a check mark in the Completed Field) or if it is late or coming due based on the Due Date.
If it is not comp...
I have a table called Contacts where I list the people’s names, company, title, phone, email, etc.
I also have a table called Meeting History where I list the people, venue, date, and notes associated with my meetings.
In that same table, I have a fi...
Thanks - I still couldn’t get it to work with your suggestions. However, I wrapped the whole formula with an IF(ISERROR({original formula}),"",{original formula)), which is kind of ugly, but it works.
Actually I take that back - my formula doesn’t quite work because it just populates everything with a checked box to the current time. Let me know if you can get the action step to work.
I couldn’t get the Zap to work the way you described it (I could trigger correctly and use grab hold of the trigger to do the action, but couldn’t figure out how to put in a formula like NOW() or TODAY() into the action step). Perhaps it is an issue...
Thanks! I think that worked. I find will find the first comma if there is more than one? In that case, it will just return the name of the first company, correct? Not a problem if that’s the case since I believe I can reorder the names in cell.
