How do you enable iterative calculation?

Hello,
I need to enable iterative calculations in one of my spreadsheet forms. I’m not seeing where this option is available?

Here is an example of the formula, We need it to timestamp the field and are only getting a circular cell reference error message

=IF(P3=TRUE,IF(Q3<>“”,Q3,NOW()),“”)

@Ethan_Newton - That option is not currently available in the UI - We will be pushing that out in a few weeks.

Could you mail your workbook’s URL to support at spreadsheet dom ? We will enable it for the workbook.

@Ethan_Newton - Iterative calculations option is now available.
You can access Iterative calculations settings from workbook Menu → Settings → Calculations.
image
image

3 Likes