Help

Circular reference

Topic Labels: Formulas
Solved
Jump to Solution
640 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Mahandry
4 - Data Explorer
4 - Data Explorer

Need Help please.

I have decided to record my workout sessions on Airtable, and I want to customize the "Set" field depending on the "Type" field. 
My goal is to format "Set" to duration when the "Type" is "Dead Hang". Otherwise, "Set" format will be number.

Screenshot from 2023-07-26 15-32-00.png

I have tried this formula, but I am getting an error message saying "circular reference". Can anyone help me with this?

Thank you

2 Solutions

Accepted Solutions
Mahandry
4 - Data Explorer
4 - Data Explorer

Perhaps what I want to do is not available on Airtable, but the desired result is like in the image, without hiding some fields. All "Set" field formats will be duration when the "Type" field is "Dead hang", and number (int) otherwise.
Screenshot from 2023-07-27 07-12-29.png

See Solution in Thread

Sho
11 - Venus
11 - Venus

Yes, you cannot specify more than one format for a single field.
It can be pseudo-replicated as a string, but the summary will not work.
If you don't mind splitting the View, maybe you could create a formula field for time display.

See Solution in Thread

3 Replies 3
Sho
11 - Venus
11 - Venus

The error is caused by a reference to {Set} in the "Set" field.
Is there another field name where you are inputting the number of seconds of dead hang?

Mahandry
4 - Data Explorer
4 - Data Explorer

Perhaps what I want to do is not available on Airtable, but the desired result is like in the image, without hiding some fields. All "Set" field formats will be duration when the "Type" field is "Dead hang", and number (int) otherwise.
Screenshot from 2023-07-27 07-12-29.png

Sho
11 - Venus
11 - Venus

Yes, you cannot specify more than one format for a single field.
It can be pseudo-replicated as a string, but the summary will not work.
If you don't mind splitting the View, maybe you could create a formula field for time display.