# Add Modulo and Random operators in Formulas
**URL:** https://community.fibery.io/t/add-modulo-and-random-operators-in-formulas/5202
**Category:** Ideas & Features
**Tags:** formulas
**Created:** [September 26, 2023, 6:41pm UTC](https://community.fibery.io/t/add-modulo-and-random-operators-in-formulas/5202 "2023-09-26T18:41:19Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)
#### Post date: [September 26, 2023, 6:41pm UTC](https://community.fibery.io/t/add-modulo-and-random-operators-in-formulas/5202/1 "2023-09-26T18:41:19Z")
Modulo and Random operator in Formulas would be very useful to me! 😀
---
### Author:  [@Sarah\_Arminta](https://community.fibery.io/u/Sarah_Arminta)
#### Post date: [September 26, 2023, 7:27pm UTC](https://community.fibery.io/t/add-modulo-and-random-operators-in-formulas/5202/2 "2023-09-26T19:27:43Z")
YES. Me too.
Funny enough, I was all ready to move everything over to Fibery and make it my main driver and had to postpone because I discovered I couldn’t do random calculations easily! They’re idk, a third of my workflow? 😕
---
### Author:  [@bear](https://community.fibery.io/u/bear)
#### Post date: [September 26, 2023, 7:38pm UTC](https://community.fibery.io/t/add-modulo-and-random-operators-in-formulas/5202/3 "2023-09-26T19:38:20Z")
Makes me curious about your workflow! 😄
---
### Author:  [@njyo](https://community.fibery.io/u/njyo)
#### Post date: [November 28, 2025, 12:57pm UTC](https://community.fibery.io/t/add-modulo-and-random-operators-in-formulas/5202/4 "2025-11-28T12:57:26Z")
Funny enough, as I am building a POC and need sample data, I find myself wanting the same `RANDOM` and `MODULO` functions. 🙂
---
### Author:  [@Kir](https://community.fibery.io/u/Kir)
#### Post date: [February 10, 2026, 4:18pm UTC](https://community.fibery.io/t/add-modulo-and-random-operators-in-formulas/5202/5 "2026-02-10T16:18:44Z")
Would be great to change assignee via formula to a random user from some group (in our case we need to assign random QA to a task in Ready to QA). I am not sure how to do this without `RANDOM`
---
### Author:  [@helloitse](https://community.fibery.io/u/helloitse)
#### Post date: [February 18, 2026, 1:16am UTC](https://community.fibery.io/t/add-modulo-and-random-operators-in-formulas/5202/6 "2026-02-18T01:16:53Z")
Will add that modulo formulas would improve our ability to compute time in the right time zone.
This may even unlock better UX natively for all customers!
---
### Author:  [@Chr1sG](https://community.fibery.io/u/Chr1sG)
#### Post date: [February 18, 2026, 8:08am UTC](https://community.fibery.io/t/add-modulo-and-random-operators-in-formulas/5202/7 "2026-02-18T08:08:42Z")
> [@helloitse](#):
>
> Will add that modulo formulas would improve our ability to compute time in the right time zone.
Can you explain why
---
### Author:  [@helloitse](https://community.fibery.io/u/helloitse)
#### Post date: [February 19, 2026, 1:50am UTC](https://community.fibery.io/t/add-modulo-and-random-operators-in-formulas/5202/8 "2026-02-19T01:50:11Z")
Sure, we would be able to use this formula
```auto
((UTC Hour - Offset + 24) % 24) * 100
```
---
### Author:  [@Chr1sG](https://community.fibery.io/u/Chr1sG)
#### Post date: [February 19, 2026, 7:03am UTC](https://community.fibery.io/t/add-modulo-and-random-operators-in-formulas/5202/9 "2026-02-19T07:03:53Z")
Sorry if I am being dim, but could you give an example of how you would make use of this formula.
---
### Author:  [@helloitse](https://community.fibery.io/u/helloitse)
#### Post date: [February 19, 2026, 7:02pm UTC](https://community.fibery.io/t/add-modulo-and-random-operators-in-formulas/5202/10 "2026-02-19T19:02:14Z")
No, not at all. I was overly excited and didn’t share enough context.
Right now Fibery leaves it to the end user to deal with timezone changes/shifts. This is one of the sneaky pain points that makes day-to-day use more complicated for users.
In my case, 7pm falls on UTC 0, so any events that happen at or after 7pm come into the Google Calendar integration as the next day. I have formula fields that help me calculate the datetimes in New York time but when I set up a daily events list, the sorting still lists UTC 0 events at the top.
So I introduced a Time calculation - which only displays the start time in 24h (i.e. 18:30) time. But this is set to UTC0 as well unless I factor in the offset for my local timezone. Since this is now a number field (not a time field) I cannot just subtract a few hours to get the right output.
I need to start with the hour in UTC time and then add my offset, and finally, reformat in 24h time