Forum Discussion

Andyshepas's avatar
Andyshepas
Copper Contributor
Sep 26, 2023

Excel Formula

Hi,   As discussed please look at the below. The issue I have is with the Dashboard tab.   Everything has a formula except Column C ‘Budgeted’ as this needs a monthly manual input and can ...
Excel
Formulas and Functions
SanthoshKunder's avatar
SanthoshKunder
Iron Contributor
Sep 27, 2023
As you said budgeted column(C) is a manual input column. Why would it update if there isn't a dynamic formula that responds to changes in the month dropdown menu?
  • Andyshepas's avatar
    Andyshepas
    Copper Contributor
    Sep 27, 2023
    Hi,

    Any ideas on what formula I would need.

    Thanks,
    Andy
    • SanthoshKunder's avatar
      SanthoshKunder
      Iron Contributor
      Sep 27, 2023
      Hi Andy- What would you like to see upon choosing a value from the month dropdown menu? I'm a bit confused. Would you want to see the values in Column C?
      • Andyshepas's avatar
        Andyshepas
        Copper Contributor
        Sep 27, 2023

        Hi,

         

        What I want to see is that when I change the month in the drop the budgeted amount in column C changes with the month selected.

         

        Thanks,

        Andy

Resources