Help with Formula

H.L.Dixon2021

I am trying to create a formula =Program Revenue+PY Rollover-Total Booked however I think because Program Revenue is also a formula it is causing an error. Help is appreciated.

Sandra Guzman

Hi @H.L.Dixon2021,

I would suggest that you create a helper column that copies the amount from the Program Revenue column. You could hide it from view and then use that Program Revenue (Helper Column) in your formula above. Your helper column would essentially be =[Program Revenue]@row. And then right click on that helper cell formula to convert it to a column formula.

Try that out and it should work.

All the best!

Sandra

Sandra Guzman

Hi @H.L.Dixon2021,

I would suggest that you create a helper column that copies the amount from the Program Revenue column. You could hide it from view and then use that Program Revenue (Helper Column) in your formula above. Your helper column would essentially be =[Program Revenue]@row. And then right click on that helper cell formula to convert it to a column formula.

Try that out and it should work.

All the best!

Sandra

H.L.Dixon2021

Thanks, I was thinking that too, but wanted to see if there were any other options :)