Modulo and Random operator in Formulas would be very useful to me! 
2 Likes
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? 
2 Likes
Makes me curious about your workflow! 
1 Like
Funny enough, as I am building a POC and need sample data, I find myself wanting the same RANDOM and MODULO functions. 
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
1 Like
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!
Can you explain why
Sure, we would be able to use this formula
((UTC Hour - Offset + 24) % 24) * 100
Sorry if I am being dim, but could you give an example of how you would make use of this formula.
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