Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula in "% Allocation" column does not copy to new rows
I'm having trouble getting a formula to copy when I insert rows. I know about the trick where the formula has to be in the row above and below the new row, that's not the problem here. I have another formula in the sheet for status and that one copies to the new row just fine. There seems to be a limitation with the "% Allocation" field, perhaps because it is tied to resource views.
I've also found that I cannot edit the formula in the "% Allocation" column once it is there either. I can edit other formulas in the sheet just fine.
Anyone have a way to get the formula to copy to newly inserted rows? Thanks!