
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 16, 2023 10:46 AM
Hello there smart folks! I am building a base for small film productions, and the industry has some odd practices I have to work around. One of those is tracking scenes on scripts in page length in fractions - specifically 8ths.
For my personal tracking I have a column that just holds the size in the total number of 8ths (so instead of showing 1/8 page it is 1, 1 and 3/8 pages is 11) which I can then total into total number of 8ths.
I now need to convert that back into pages in fraction form to display on one of my reports. So say I have 10 scenes over 5 3/8 pages (so my total is 43). How do I create that 5 3/8 to display?
I hope this makes sense!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 16, 2023 11:26 AM
With some work, this could probably be reduced to one field/formula. But for expediency's sake, try this:
Whole Numbers formula:
Remainders formula:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 16, 2023 07:39 PM
Here is another option ...
CONCATENATE(
ROUNDDOWN({Eigths}/8, 0),
IF(
MOD({Eigths}, 8),
" " & MOD({Eigths}, 😎 & "/8"
)
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 16, 2023 11:26 AM
With some work, this could probably be reduced to one field/formula. But for expediency's sake, try this:
Whole Numbers formula:
Remainders formula:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 16, 2023 11:36 AM
THANK YOU! Formulas make my brain hurt and I was just staring at this for a while lol. Unless someone teaches us both how to make this smaller I will use it....hooray for hidden fields 😄

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 16, 2023 07:39 PM
Here is another option ...
CONCATENATE(
ROUNDDOWN({Eigths}/8, 0),
IF(
MOD({Eigths}, 8),
" " & MOD({Eigths}, 😎 & "/8"
)
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 17, 2023 12:59 PM
What a fantastic community 🙂 Thank you ever so much!!!!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 26, 2023 10:14 AM
I'm trying this one (ya reduced fields!) but keep getting errors for missing opening parenthesis?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 07, 2024 11:10 PM
Circling back to this, wondering if anyone else has a formula suggestion to reduce this to a 2-field setup? Sadly what kuovonne suggested continues to come back with errors for me. Would be nice to reduce my very large table by the 2 extra fields 🙂
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 04, 2025 08:10 AM
Hi, I feel very silly asking this. I'm trying out airtable for script breakdowns also and I want to display the page count in fractions but I don't track the number of eighths separately. Is there a way to just input fractions into a column and have them displayed as fractions instead of making a whole formula and a separate column to turn 11 (in a how many eighths column) into 1 3/8.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 04, 2025 08:44 AM
If you don't need to have anything else use the number, you can just have it as a text box and put the fraction value in to display. However my setup I have the pages being summarized in other places so it won't do the job lol.
