Forum Discussion
Column formula is not working
Hi, I am not a data person but need to create the report. I think the solution to problem will be simple but i dont know it. I have simple ms form data in excel sheet. where i have created...
Hi Hans, Thanks for response. that were i am facing an issue. i want the every new response/data to automatically get the column formula. i have implemented it the same way. the week column formula is working for every new entry and the month column one isn,t.
1) In File > Options > Proofing > AutoCorrect Options... > AutoFormat As You Type tab, make sure that the check box "Fill formulas in tables to create calculated columns" is ticked.
2) Clear the colum n in the table (except for the header of course), then enter the formula =MONTH([@[Completion time]]) in the cell below the header. Excel should automatically fill the entire table column.
- Thanks. Point 1 was already on place.
did the same thing as you advised in point 2 and submitted a new response and still received the same error.Do you mean that Excel spontaneously enters the fixed number 36 in a column with formulas?
HansVogelaar No, the value keeps changing and its not a fix number. As you can see the value has changed from 36 to 53.