The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

CarmenBrower's avatar
CarmenBrower
New Contributor II
3 years ago

Is it possible to load data via excel with an XF formula?

I am knew to the OneStream Software. Is there a way to load data outside of a form, and not through workflow? Meaning, is there an xf formula that can be used in excel that will write to a specific d...
Excel Add In
PeterFu's avatar
PeterFu
Contributor II
3 years ago

Hi Carmen,

 

Yes, OneStream has a XFSetCell formula. See print screen below.

 

 

Peter

CarmenBrower's avatar
CarmenBrower
New Contributor II
3 years ago

Thanks Peter. Is there a a formula builder on the OneStream XF addin ribbon? (other tools I've worked with have a formula builder displaying all the XF functions that are available. 

  • PeterFu's avatar
    PeterFu
    Contributor II
    3 years ago

    Hi Carmen,

     

    OneStream has a MarketPlace Solution called, Admin Solution Tools. That one contains a Member Formula Builder. See print screen below.

     

     

    Peter

  • PeterFu's avatar
    PeterFu
    Contributor II
    3 years ago

    Hi Carmen,

     

    Sorry, I read too quick, I gave you a solution inside of Onestream. However, you will find list of the different Onestream functions in Excel. You get the window with all the fields that you can see in print screen I posted earlier. 

     

    Peter