Today Formula

Claire Kadlecek

I have a #blocked statement in the cell that shows the Today formula =Today (). The cell exists to show today's date and then use it for other formulas. I'm not sure how to proceed.

Christian Graf

Is the column a date column?

Claire Kadlecek

Yes, the column is a date column.

Genevieve P.

Hi @Claire Kadlecek

If there's a circular reference error in one of the formulas looking at your TODAY() formula, this may return a BLOCKED error for this cell.

Would you be able to check your formulas referencing this cell to see if any of them have an error?

An alternative would be to use a Record a Date workflow to set the date each day instead of a formula, see: Set the current date with the Record a Date action.

Cheers!

Genevieve