Formula Fix
The formula worked perfectly fine until I added 2 columns. I’m just trying to adjust 2 numbers but the formula will not let me. This may be a data validation issue but I am not sure. Here is the formula: =INDEX(‘Hard Keys Inventory’!$A:$AA,XMATCH(LEFT([@Room],3),LEFT(‘Hard Keys Inventory’!$A:$A,3)),SWITCH(MID([@Room],4,1),””,3,”A”,11,”B”,19)). The 2 numbers I needs changed are 11 & 19 at the end of the formula. The 11 needs to be changed to 12 and the 19 needs to be changed to 21 I believe. When I change the numbers I get the following message “This field is calculated using a formula and should not be entered manually. Please click ‘CANCEL'”. This message is an Error Alert in Data Validation with a Style of Stop. I just need to know how to fix this issue.
Would you please help me out here?
Carl
@m_tarler Formula Change/Fix Key Log FixThe formula worked perfectly fine until I added 2 columns. I’m just trying to adjust 2 numbers but the formula will not let me. This may be a data validation issue but I am not sure. Here is the formula: =INDEX(‘Hard Keys Inventory’!$A:$AA,XMATCH(LEFT([@Room],3),LEFT(‘Hard Keys Inventory’!$A:$A,3)),SWITCH(MID([@Room],4,1),””,3,”A”,11,”B”,19)). The 2 numbers I needs changed are 11 & 19 at the end of the formula. The 11 needs to be changed to 12 and the 19 needs to be changed to 21 I believe. When I change the numbers I get the following message “This field is calculated using a formula and should not be entered manually. Please click ‘CANCEL'”. This message is an Error Alert in Data Validation with a Style of Stop. I just need to know how to fix this issue. Would you please help me out here? Carl Read More
