Issue with Formula Application in Table Row 157

·

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.

4 comments

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 B.
·
·
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!