Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

Issue with Formula Application in Table Row 157

Andrei Baloleanu (Adyntel)

·

·

I have this table where I applied a formula (see opening hours) and on row 157 the formulas did not apply at all although the columns I’m using as data source have some data in them, not all but some have so I was expecting to see the formulas work for those.

Issue with Formula Application in Table Row 157 | Clay

4 comments

· Sorted by Oldest

Channeled
APP
·
·
This issue is likely due to how your formula was set up. The formula might be assuming there would be a response for every row, but that's not happening for row 157. Try adding conditional logic to your formula like "if {{response}} exists..." so it only processes when the required data exists. This prevents errors when certain columns are empty. If the issue persists after modifying your formula, try performing a hard refresh (Ctrl+Shift+R on Windows or Cmd+Shift+R on Mac) to ensure all data is properly loaded.
Sources: Sources | Documentation | Clay University Table columns | Documentation | Clay University
Channeled
APP
·
·
Hey Andrei! Thanks for waiting patiently while I figured this out. Created a loom for you outlining my thought process and recommended solution. Do let me know if there is anything else that I can help you with! :)
Andrei Baloleanu (Adyntel)
·
·
lol, I even looked at the formula for a spelling and didn’t see anything…. 🤦‍♂️ thanks a mil for this!!
Channeled
APP
·
·
Hello Andrei! No problem at all, easy to miss! If there is nothing else I am going to go ahead and close this ticket for now. Do reach out if you need further assistance!